Multiple choice technology databases

What funcion is used to kill a job scheduled in scheduler?

  1. kill

  2. kill_job

  3. stop_job

  4. stop

  5. None
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

STOP_JOB is the correct DBMS_SCHEDULER procedure to stop or kill a running scheduled job. There is no KILL or KILL_JOB procedure in the scheduler package.

AI explanation

Oracle's DBMS_SCHEDULER.STOP_JOB procedure is the correct function to terminate a currently running scheduled job. Unlike simply dropping or disabling a job, STOP_JOB specifically halts an in-progress execution, which is why it's the documented procedure for this purpose rather than a generic 'kill' or 'stop' command.

Keep practicing — related questions