Create,Run,Stop,Drop DBMS_SCHEDULER Jobs Posted by MOHAMMED ABDUL HAMEED on 12:26 AM

Create the job :

BEGIN
SYS.DBMS_SCHEDULER.CREATE_JOB
(job_name                    => `SYS.XXXXXXX`,
 program_name            => `SYS.XXXXXXX`,
 schedule_name            => `SYS.XXXXXXX`);
END;
/

Run the job :

BEGIN
SYS.DBMS_SCHEDULER.RUN_JOB
(job_name  => 'SYS.XXXXXXX');
END;
/

Stop the job : 

BEGIN
SYS.DBMS_SCHEDULER.STOP_JOB
(job_name  => 'SYS.XXXXXXX');
END;
/

Drop the job :

BEGIN
SYS.DBMS_SCHEDULER.DROP_JOB
(job_name  => 'SYS.XXXXXXX');
END;
/