Concurrent manager job scheduling management tools

There are several main methods for submitting a concurrent manager job, the concsub utility, the fnd_request command, dbms_scheduler and the ora_rw20_run executable.

Concurrent manager jobs with concsub

Oracle Applications provides the concsub utility (concurrent manager submit) procedure for submitting concurrent manager jobs on-demand and scheduling concurrent manager jobs.

CONCSUB Parameter Arguments:

<APPS username>/<APPS password> \ Required
<Responsibility Application Short Name> \Required
<Responsibility Name> \Required
<User Name> \Required
[WAIT=N|Y|<n seconds>] \Optional, Default value = N
CONCURRENT \Required
<Program application short name> \Required
<Program Name> \Required[PROGRAM_NAME=?<description>?] \Optional
[REPEAT_TIME=<resubmission time>] \Optional
[REPEAT_INTERVAL=<number>] \Optional
[REPEAT_INTERVAL_UNIT=<resubmissionunit>] \Optional, Default = DAYS
[REPEAT_INTERVAL_TYPE=<resubmissiontype>] \Optional
[REPEAT_END=<resubmission end date andtime>] \Optional
[START=<Requested Start Date>]Optional, Default = Current time
[REPEAT_DAYS=<number of days>] \Optional
[IMPLICIT=<type of concurrent request> ] \Optional, Default = NO[PRINTER=<name of printer>] \Optional
[NUMBER_OF_COPIES=<number of copies>]Optional

Example invocation of concsub to submit a concurrent manager job:

CONCSUB APPS/APPS SYSADMIN 'systems Administrator? SYSADMIN WAIT=NCONCURRENT FND FNDFMRTC PROGRAM_NAME=??Register Custom Tables Weekly??REPEAT_INTERVAL=7 REPEAT_INTERVAL_UNIT=?DAYS? REPEAT_INTERVAL_TYPE='sTART? START=??08-JUN-98 23:55:00?? CGL APPLSYS ALL CGL
 

Concurrent manager jobs with fnd_request

The fnd_request PL/SQL package can be used to trigger a concurrent manager request.  Here is the syntax:

   fnd_request.submit_request(parameters)

Here is a PL/SQL example using fnd_request package and the submit_request procedure to submit a concurrent manager job:

begin
fnd_global.apps_initialize(user_id,resp_id,appl_resp_id)

v_request_id := fnd_request.submit_request(app_name,conc_pgm_shortname,description,paramers)
commit;

if v_request_id > 0 then

   dbms_output.put_line('Successfully submitted')
else
   dbms_output.put_line('Not Submitted');
end;
 

Executing concurrent manager jobs with ora_rw20_run

You can also run a concurrent manager job on-demand with the ora_rw20_run OS command.  The example below is a Linux command to  start a concurrent manager job named 12345.  The backslash "\" characters are Linux multi-line command extensions:

root> ora_rw20_run \
   P_CONC_REQUEST_ID=12345 \
   p_unit="ABC' \
   p_region="NYC' \
   report=/u01/reports/myreport.rdf \
   batch=yes \
   destype=file \
   desname=/u01/reports/myfile.out \
   desformat=PDF

Scheduling concurrent manager jobs with dbms_job and dbms_scheduler

All concurrent manager job are accessible via the dbms_job and dbms_scheduler interface.  For details, see Dr. Hall's book "Oracle Job Scheduling".

Changing Dispatching Priority within the Concurrent Manager