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

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 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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 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.
-----------------

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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 21:38:27 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.