Code To Delete Wrapper Program and Job

Begin 


/* TABLES REQUIRED 

DBA_SCHEDULER_JOB_RUN_DETAILS

DBA_SCHEDULER_PROGRAMS

DBA_SCHEDULER_JOBS

*/


DBMS_SCHEDULER.DROP_JOB(JOB_NAME => 'XX_JOB_NAME');

DBMS_SCHEDULER.DROP_Program(Program_NAME => 'XX_PROGRAM_NAME');


END;

No comments:

Post a Comment