Parameter Name | Description |
---|---|
Action | Specifies the action to be performed on the scheduler object. Valid values are: • ADD – Add • READ – Read • CHNG – Change • DEL – Delete |
Name | The name of the scheduler program on which the operation needs to be performed. |
description | Description of the scheduler program. |
batchCode | Batch code of the product batch process for which the program is being created. |
userId | ID under which the batch process will run. |
threadCount | Use Thread Count to control whether a background process is run single threaded or in multiple parallel threads. This value defines the total number of threads that have been scheduled |
businessDate | Process date to be used for batch job. If no value is provided, the current date will be used. The format of the date must be in a recognizable format. |
maxTimeoutMins | Maximum timeout, in minutes, for transactions to avoid ORA-01555 Snapshot too old errors. Default is 15. |
rerunNumber | Is only used for product background processes that download information that belongs to given run number. It should only be supplied if you need to download an historical run (rather than the latest run). |
threadPool | The default threadpool to use. The installation default threadpool is 'DEFAULT'. |
minRunStatus | Minimum Run Status that will cause this procedure to exit. The default is RUN_STAT_COMPLETED (40). Other values supported: • 10 - RUN_STAT_PENDING • 20 - RUN_STAT_IN_PROGRESS • 30 - RUN_STAT_ERROR • 40 - RUN_STAT_COMPLETED |
raiseError | If the min_run_status is set a value less than 40, this parameter is set to true and the job status matches the value of the min_run_status then raise an application error. This allows the chain to support conditional branches or stop chains on conditions. Default is false. |
threadNotifications | Whether if an error in any thread should trigger a notification event. Default is true. See Notification Options for more information. |
parmName (list parameter) | The name of the parameter to the batch process, if applicable. |
parmValue (list parameter) | The corresponding value of the parameter to the batch process, if applicable. parmValue and parmName pairs should be defined in repeated lists. |
optionName (list parameter) | Option name to set/unset before program is executed |
optionScope (list parameter) | Corresponding scope for the options to set/unset before program is executed. The scope can be global or per batch code. |
optionValue (list parameter) | Corresponding value for the option name. |
Parameter Name | Description |
---|---|
action | Specifies the action to be performed on the scheduler object. Valid values are: • ADD – Add • READ – Read • CHNG – Change • DEL – Delete |
name | The name of the scheduler chain on which the operation needs to be performed. |
description | Description of the scheduler chain. |
stepName (list parameter) | The name of the step within the scheduler chain |
programName (list parameter) | The program name that is part of the corresponding step. |
condition (list parameter) | A condition that must be met to complete the step and to transition to the next step or to end the chain execution. |
Parameter Name | Description |
---|---|
action | Specifies the action to be performed on the scheduler object. Valid values are: • ADD – Add • READ – Read • CHNG – Change • DEL – Delete |
name | The name of the scheduler’s schedule object being created/edited/read/deleted. |
description | Description of the schedule. |
repeatInterval | The schedule’s repeat interval to be specified in the format supported by Oracle DBMS Scheduler. (Refer to Oracle DBMS scheduler’s documentation) |
Parameter Name | Description |
---|---|
Action | Specifies the action to be performed on the scheduler object. Valid values are: • ADD – Add • READ – Read • CHNG – Change • DEL – Delete |
Name | The name of the scheduler’s job object being created/edited/read/deleted. |
Description | Description of the scheduler’s job object. |
programName | The name of the scheduler’s program to which this job should be associated with. |
chainName | The name of the scheduler’s chain to which this job should be associated with. |
scheduleName | The name to the schedule’s schedule object based on which this job needs to be executed. |
enabled | Specified if this job should be enabled or disabled. |
Parameter Name | Description |
---|---|
Type | Specifies the type of scheduler object whose list is to be retrieved. Valid values are: • PROG – DBMS Scheduler Program • CHAN – DBMS Scheduler Chain • SCHD – DBMS Scheduler Schedule • JOB – DBMS Scheduler Job |
Name | Name to search with. Appending ‘%’ to the end of name will perform a ‘like’ query resulting in a list of objects starting with the name provided. |
Parameter Name | Description |
---|---|
Name | Name of the scheduler’s job object to be submitted for execution. |
Parameter Name | Description |
---|---|
Name | Name of the scheduler’s job object whose details are to retrieved/read. |
Status | Status of the DBMS scheduler job. |
startDate | The start date of the DBMS scheduler job. |
runDuration | The run duration of the DBMS scheduler job. |
stepName (list parameter of "steps" list) | The name of the DBMS Scheduler job’s step. |
Status (list parameter of "steps" list) | The status of the corresponding step. |
runDuration | The run duration of the corresponding step. |
Parameter Name | Description |
---|---|
jobStatus | The status based on which the list of DBMS scheduler jobs list must be retrieved. Valid values are: • RUN – Running Jobs • COMP – Completed Jobs |
startDate | The start date of the date range for which the details have to be retrieved. |
endDate | The end date of the date range for which the details have to be retrieved. |
jobStatus (list parameter of "jobs" list) | The status of the job. |
runDate (list parameter of "jobs" list) | The execution date of the corresponding job. |
runDuration (list parameter of "jobs" list) | The run duration of the corresponding job. |
chainName (list parameter of "jobs" list) | The name of the associated chain (if applicable) |
stepName (list parameter of "steps" list) | The name of the chain step within the job. |
stepState (list parameter of "steps" list) | The state of the corresponding step. |
batchCode (list parameter of "steps" list) | The batch code of the corresponding step. |
batchNumber (list parameter of "steps" list) | The batch number of the corresponding step. |
batchRerunNumber (list parameter of "steps" list) | The batch rerun number of the corresponding step. |
Error Details (list parameter of "steps" list) | The error corresponding to the step (if applicable). |
Parameter Name | Description |
---|---|
name | The name of the DBMS scheduler job to cancel. |
Parameter Name | Description |
---|---|
batchCode | Batch code of the batch process for which the failed thread needs to be restarted. |
userId | User Id of the user using which the batch thread needs to be restarted. |
threadNumber | The thread number of the batch program that needs to be restarted. |
threadCount | Use Thread Count to control whether a background process is run single threaded or in multiple parallel threads. This value defines the total number of threads that have been scheduled |
businessDate | Process date to be used for batch job. If no value is provided, the current date will be used. The format of the date must be in a recognizable format. |
maxTimeoutMins | Maximum timeout, in minutes, for transactions to avoid ORA-01555 Snapshot too old errors. Default is 15. |
rerunNumber | Is only used for batch processes that download information that belongs to given run number. It should only be supplied if you need to download an historical run (rather than the latest run). |
threadPool | The default threadpool to use. The installation default threadpool is 'DEFAULT'. |
parmName (list parameter) | The name of the parameter to the batch process, if applicable. |
parmValue (list parameter) | The corresponding value of the parameter to the OUAF batch process, if applicable. parmValue and parmName pairs should be defined in repeated lists. |
Parameter Name | Description |
---|---|
jobName | The name of the DBMS scheduler job to cancel. |