Home » RDBMS Server » Server Administration » removing jobs from 10g schduler
removing jobs from 10g schduler [message #219262] Tue, 13 February 2007 13:20 Go to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
All
I need to remove jobs from 10g job schduler and apply DST patch and put back this jobs in schduler after patching. I do not want to delete the jobs, but just remove them from schduler. Any idea how do I do that??

Thanks
Toshi Das
Re: removing jobs from 10g schduler [message #219267 is a reply to message #219262] Tue, 13 February 2007 13:56 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You can disable the job with:

BEGIN
DBMS_SCHEDULER.DISABLE('<job_name>');
END;
/
Re: removing jobs from 10g schduler [message #219275 is a reply to message #219267] Tue, 13 February 2007 14:44 Go to previous messageGo to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
thanks and how to enable it back?

Thank
Re: removing jobs from 10g schduler [message #219299 is a reply to message #219275] Tue, 13 February 2007 22:28 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
BEGIN
DBMS_SCHEDULER.ENABLE('<job_name>');
END;
/



regards
Taj
Previous Topic: Migrating from 8i to 9i rel2
Next Topic: resmgr:waiting in end wait
Goto Forum:
  


Current Time: Fri Dec 02 22:46:42 CST 2016

Total time taken to generate the page: 0.30262 seconds