Oracle job checking and deleting

Check job

SQL>SET LINE 500;
SQL>col WHAT for a200;
SQL>select SCHEMA_USER, job, what from dba_jobs;

Delete job

(for example,the job number is 4003)

SQL>exec dbms_job.remove (4003);

Leave a Reply