Home » RDBMS Server » Server Administration » to take a job offline
to take a job offline [message #331589] Fri, 04 July 2008 02:47 Go to next message
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
Re: to take a job offline [message #331596 is a reply to message #331589] Fri, 04 July 2008 03:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What job?
Oracle one? Use dbms_job or dbms_scheduler.

Regards
Michel
Re: to take a job offline [message #331635 is a reply to message #331596] Fri, 04 July 2008 04:49 Go to previous messageGo to next message
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.
-----------------

Re: to take a job offline [message #331915 is a reply to message #331635] Sun, 06 July 2008 10:12 Go to previous message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


Thank u very much its working.


Thanks & Regards,
Seenu
Previous Topic: How Can find how much database is running in Oracle server
Next Topic: Last time of statement execution
Goto Forum:
  


Current Time: Sun Dec 11 00:14:46 CST 2016

Total time taken to generate the page: 0.21188 seconds