Monday, September 26, 2011

DBMS_JOB

Submitted/scheduled job can be found in:
dba_jobs
Running jobs can be found in:
dba_jobs_running
Remove a job:
dbms_job.remove(jobno);
DBMS_JOB have been deprecated and replaced by DBMS_SCHEDULER (available from 10.1). Read more about DBMS_SCHEDULER here.

No comments:

Post a Comment

javascript:void(0)