Tag: DBMS_JOB.SUBMIT

  • DBMS_JOB API Example

    DBMS_JOB API example to kill DB session of a concurrent request: The DBMS_JOB package schedules and manages jobs in the job queue. Main Procedures that will be used: DBMS_JOB.SUBMIT submits the job to the job queue. You must issue a COMMIT statement immediately after the statement. Parameters: job: Number of the job being run. what:…