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);
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);