Where to find scheduled jobs (dbms_scheduler) [message #440495] |
Mon, 25 January 2010 03:51 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/111270.jpg) |
didiera
Messages: 134 Registered: August 2007 Location: Mauritius
|
Senior Member |
|
|
Hello,
first my apologies if I posted in the wrong area of the forum. I wanted to know if there were a dictionnary view or dynamic performance view that stored jobs regsitered via the dbms_scheduler package of Oracle 10g? I can see the ones registered with the deprecated dbms_jobs but not the others. Which view is it please?
regards,
Didier
|
|
|
|
|
|
|
|
|
|
Re: Where to find scheduled jobs (dbms_scheduler) [message #440539 is a reply to message #440528] |
Mon, 25 January 2010 08:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Do not trust what sites say (unless it is Oracle one, although...), think and test by yourself.
As Tom I most often use DBMS_JOB for the reasons I wrote in the Wiki pages and also because I currently don't need windowing features. I think this latter point with the possibility to stop the execution of job is the great add-on of DBMS_SCHEDULER.
Remember DBMS_JOB is transactional (that is part of your transaction), DBMS_SCHEDULER is not (it is autonomous), depending on your needs one or the other is better.
Regards
Michel
[Updated on: Mon, 25 January 2010 08:02] Report message to a moderator
|
|
|
|