-
DBMS_JOB syntax query - how to delete/disable job
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
-
-
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/
Last edited by mbartov; 04-25-2003 at 11:24 AM.
-
Originally posted by mbartov
BEGIN dbms_job.broken(3,FALSE,'');END;
commit;
Err, the second parameter in the above call to BROKEN procedure should have been TRUE, not FALSE. Yes, I know, a typo...
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Re: DBMS_JOB syntax query - how to delete/disable job
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.
Disable => dbms_job.broken
Delete => dbms_job.remove
Just try desc "dbms_job"
-nagarjuna
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|