How do you disable or delete a scheduled job? (In 8.1.5.0)
I'm RTFM but can't seem to find what I want. :)
Printable View
How do you disable or delete a scheduled job? (In 8.1.5.0)
I'm RTFM but can't seem to find what I want. :)
I doubt you RTFM, go read supplied pl/sql reference guide
You should have STFWQuote:
Originally posted by JMac
How do you disable or delete a scheduled job? (In 8.1.5.0)
I'm RTFM but can't seem to find what I want. :)
http://download-east.oracle.com/docs.../jobq.htm#1057
Thanks chaps, you are so understanding and supportive.
;)
BEGIN dbms_job.broken(3,TRUE,'');END;
commit;
where 3 is the jobno.
I just posted an integrated set of GUI tools to administer and tune the Oracle database. One of the many functions is a GUI interface to manage the Oracle Jobs.
Feel free to contact me, if you need help (michelbartov@yahoo.com). The link is http://www.barsoft.net/
Err, the second parameter in the above call to BROKEN procedure should have been TRUE, not FALSE. Yes, I know, a typo...Quote:
Originally posted by mbartov
BEGIN dbms_job.broken(3,FALSE,'');END;
commit;
Disable => dbms_job.brokenQuote:
Originally posted by JMac
How do you disable or delete a scheduled job? (In 8.1.5.0)
I'm RTFM but can't seem to find what I want. :)
Delete => dbms_job.remove
Just try desc "dbms_job"