OraFAQ Forum: Server Administration » to take a job offline

Home » RDBMS Server » Server Administration » to take a job offline

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

to take a job offline [message #331589]

Fri, 04 July 2008 02:47

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

Hi Friends,

I have used TOAD to take a job offline and online. I like to know how can we take a job online and offline using the query.

The version of my database is 10.1.0.2.0

Thanks in Advance,

Seenu

Report message to a moderator

Re: to take a job offline [message #331596 is a reply to message #331589]

Fri, 04 July 2008 03:15

Michel Cadot
Messages: 68667
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What job?
Oracle one? Use dbms_job or dbms_scheduler.

Regards
Michel

Report message to a moderator

Re: to take a job offline [message #331635 is a reply to message #331596]

Fri, 04 July 2008 04:49

ora110
Messages: 42
Registered: September 2007
Location: China

Member

you can serch it from your oracle official documents.
----------
dbms_job.broken(job_numbo,true) --to stop a job
dbms_job.broken(job_number,false) --to start a job.
don't forget runing a sql "commit" to submit.
-----------------

Report message to a moderator

Re: to take a job offline [message #331915 is a reply to message #331635]

Sun, 06 July 2008 10:12

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

Thank u very much its working.

Thanks & Regards,
Seenu

Report message to a moderator

Previous Topic:	How Can find how much database is running in Oracle server
Next Topic:	Last time of statement execution

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 22 15:05:30 CDT 2024