Get Information About a Job

Use this API to retrieve information about a Job by passing its JOB_ID.

Name

CDR_PUB_EXE_RUNTIME.GetJobInfo

Signature

PROCEDURE GETJOBINFO( 
  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_NJOBID  IN    CDR_JOBS.JOB_ID%TYPE, 
  PO_RSUBMISSION_V  OUT    CDR_SUBMISSIONS_V%ROWTYPE, 
  PO_RJOB_V  OUT    CDR_JOBS_V%ROWTYPE 
); 

Parameters

This API has standard parameters (see Standard Parameters) and the following parameters:

• PI_NJOBID (Mandatory) Enter the JOB_ID of the job you want information about. You can get the Job ID by running CDR_PUB_EXE_RUNTIME. Get Currently Executing Job ID.
• PO_RSUBMISSION_V This is an output parameter. The API returns the row corresponding to the SUBMISSION_ID associated with the JOB_ID value in CDR_JOBS from the CDR_SUBMISSIONS table.
• PO_RJOB_V This is an output parameter. The API returns the row corresponding to the JOB_ID from the CDR_JOBS table.