Re: convert_dbms_job in 11.2

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 15 Dec 2015 17:34:38 -0500

Hi Patrice,
I checked on both 11.2.0.4 and 12.1.0.2, there is no such procedure. What is more, even the almighty and omniscient Google doesn't know anything about that procedure. If it's not on Google, it doesn't exist. It shouldn't be a problem to write a Perl script which can do that.
Regards

On 12/15/2015 03:21 PM, Patrice sur GMail wrote:

I see a reference in psoug to a dbms_scheduler.convert_dbms_job procedure, but when I look at the dbms_scheduler package in 11.2.0.4 it's not there.

A search in Oracle Support for convert_dbms_job returns nothing.

Did Oracle remove it at some point?

http://psoug.org/reference/dbms_scheduler.html


Did someone write a script to do this? Databases can contain hundreds of jobs, I imagine someone must have decided to script this conversion.

-- Patrice

My profiles: Facebook <http://www.facebook.com/home.php?#%21/profile.php?id=100000206805521>LinkedIn <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>Twitter <http://www.twitter.com/PatriceBoivin>


--
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com

Other related posts: