Give The Parameters Of The Dbms_job.submit Procedure ?

1.	Give The Parameters Of The Dbms_job.submit Procedure ?
Answer» The DBMS_JOB.SUBMIT procedure adds a new job to the job queue. It TAKES four PARAMETERS as input and returns the job number as the output though the JOB parameter. The parameters of the DBMSJOB.SUBMIT procedure are as follows: JOB— Refers to the OUT parameter that gives the output of the job number, which is the unique identifier for the job WHAT— Refers to the IN parameter, which provides the PL/SQL code to be executed NEXT_DA TE —Refers to the IN parameter, which provides the next execution date of the job INTERVAL —Refers to the IN parameter for the interval USED to calculate the next execution date NO_PARSE —Refers to the IN parameter, which is a Boolean FLAG INDICATING whether to parse the job at the time of job submission The DBMS_JOB.SUBMIT procedure adds a new job to the job queue. It takes four parameters as input and returns the job number as the output though the JOB parameter. The parameters of the DBMSJOB.SUBMIT procedure are as follows:

Answer»

The DBMS_JOB.SUBMIT procedure adds a new job to the job queue. It TAKES four PARAMETERS as input and returns the job number as the output though the JOB parameter. The parameters of the DBMSJOB.SUBMIT procedure are as follows:

JOB— Refers to the OUT parameter that gives the output of the job number, which is the unique identifier for the job
WHAT— Refers to the IN parameter, which provides the PL/SQL code to be executed
NEXT_DA TE —Refers to the IN parameter, which provides the next execution date of the job
INTERVAL —Refers to the IN parameter for the interval USED to calculate the next execution date
NO_PARSE —Refers to the IN parameter, which is a Boolean FLAG INDICATING whether to parse the job at the time of job submission

The DBMS_JOB.SUBMIT procedure adds a new job to the job queue. It takes four parameters as input and returns the job number as the output though the JOB parameter. The parameters of the DBMSJOB.SUBMIT procedure are as follows:

Give The Parameters Of The Dbms_job.submit Procedure ?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment