Home » SQL & PL/SQL » SQL & PL/SQL » Help -> DBMS_JOB.BROKEN
Help -> DBMS_JOB.BROKEN [message #294853] Sun, 20 January 2008 03:38 Go to next message
cgmsuresh
Messages: 29
Registered: December 2007
Location: http://maps.google.com/ma...
Junior Member

Hi,

Here 141 is jobno.
exec dbms_job.broken(141, TRUE, NEXT_DAY(SYSDATE, 'MONDAY'));

Here BROKEN flag set to TRUE.

I am having doubt that, this job 141 will be executed or not?

Thanks and Regards,
Suresh.
Re: Help -> DBMS_JOB.BROKEN [message #294856 is a reply to message #294853] Sun, 20 January 2008 04:10 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
If only there was some king of notes that one could go and read to find out about these things. They should be called something like, oh I don't know DOCUMENTATION
Have you read the linked article already? If not, why not. If you have, do you still have doubts?
Re: Help -> DBMS_JOB.BROKEN [message #294859 is a reply to message #294853] Sun, 20 January 2008 04:27 Go to previous messageGo to next message
cgmsuresh
Messages: 29
Registered: December 2007
Location: http://maps.google.com/ma...
Junior Member

Thanks pablolee

[Updated on: Sun, 20 January 2008 04:27]

Report message to a moderator

Re: Help -> DBMS_JOB.BROKEN [message #294861 is a reply to message #294853] Sun, 20 January 2008 04:37 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Use, DBMS_SCHEDULER instead of DBMS_JOB. It is better to manage and better flexible with more task.
Re: Help -> DBMS_JOB.BROKEN [message #294866 is a reply to message #294861] Sun, 20 January 2008 04:56 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Arju wrote on Sun, 20 January 2008 10:37
Use, DBMS_SCHEDULER instead of DBMS_JOB. It is better to manage and better flexible with more task.

Comment is only valid if OP is on 10g or later
Re: Help -> DBMS_JOB.BROKEN [message #294867 is a reply to message #294866] Sun, 20 January 2008 05:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
pablolee wrote on Sun, 20 January 2008 11:56
Arju wrote on Sun, 20 January 2008 10:37
Use, DBMS_SCHEDULER instead of DBMS_JOB. It is better to manage and better flexible with more task.

Comment is only valid if OP is on 10g or later

Comment is only valid if you have a complex job and/or schedule and if you don't need job is part of your transaction.

Regards
Michel

[Updated on: Sun, 20 January 2008 05:36]

Report message to a moderator

Re: Help -> DBMS_JOB.BROKEN [message #294871 is a reply to message #294867] Sun, 20 January 2008 05:44 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Michel Cadot wrote on Sun, 20 January 2008 11:36
pablolee wrote on Sun, 20 January 2008 11:56
Arju wrote on Sun, 20 January 2008 10:37
Use, DBMS_SCHEDULER instead of DBMS_JOB. It is better to manage and better flexible with more task.

Comment is only valid if OP is on 10g or later

Comment is only valid if you have a complex job and/or schedule and if you don't need job is part of your transaction.

Regards
Michel


Comment is valid Smile
Previous Topic: Language problem
Next Topic: HELP -> DBMS_LOG.FILEEXISTS
Goto Forum:
  


Current Time: Tue Dec 06 04:56:26 CST 2016

Total time taken to generate the page: 0.16118 seconds