DBMS_JOB syntax query - how to delete/disable job

[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.

[pando]

I doubt you RTFM, go read supplied pl/sql reference guide

[adewri]

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.

You should have STFW

http://download-east.oracle.com/docs.../jobq.htm#1057

[JMac]

Thanks chaps, you are so understanding and supportive.

[mbartov]

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/

[jmodic]

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...

[nagarjuna]

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"