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.