OraFAQ Forum: Server Administration » removing jobs from 10g schduler

Home » RDBMS Server » Server Administration » removing jobs from 10g schduler

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

removing jobs from 10g schduler [message #219262]

Tue, 13 February 2007 13:20

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

Report message to a moderator

Re: removing jobs from 10g schduler [message #219267 is a reply to message #219262]

Tue, 13 February 2007 13:56

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You can disable the job with:

BEGIN
DBMS_SCHEDULER.DISABLE('<job_name>');
END;
/

Report message to a moderator

Re: removing jobs from 10g schduler [message #219275 is a reply to message #219267]

Tue, 13 February 2007 14:44

toshidas2000
Messages: 120
Registered: November 2005

Senior Member

thanks and how to enable it back?

Thank

Report message to a moderator

Re: removing jobs from 10g schduler [message #219299 is a reply to message #219275]

Tue, 13 February 2007 22:28

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

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

regards
Taj

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 15:51:33 CST 2024