Start a Job
Use this API to start the execution of a job.
Name
CDR_PUB_EXE_SUBMISSION.StartJob
Signature
PROCEDURE STARTJOB( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT VARCHAR2, X_MSG_COUNT OUT NUMBER, X_MSG_DATA OUT VARCHAR2, PI_VEXECMODE IN VARCHAR2 := 'NONE', PI_NJOBID IN CDR_JOBS_V.JOB_ID%TYPE, PI_NSTREAMID IN NUMBER := NULL );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- PI_VEXECMODE (Mandatory) Enter the mode of execution. There are four possible values: SYNCHRONOUS (start the job and wait for completion), QUEUE (enqueue the job on the LSH queues), DIRECT (directly submit the job to OWB but do not wait), STREAM (The stream ID has to be set if this mode is used).
- PI_NJOBID (Mandatory) Enter the Job_ID of the job to be executed.
- PI_NSTREAMID Enter the OWB Stream ID. The default value is Null. This parameter is required only if mode=STREAM.
Parent topic: Create Submission Records