Re: Scheduler Jobs

Andrew

I had upgraded the Database from 8i to 10g and converted 30 dbmsJobs to Scheduler running at various interval. The test database was created few month back and lost the drive where I stored all scheduler scripts. Now in order to move to Production, I want to remove the dbms Job to 10g schedulere and so want to create the DDL. It is difficult to go with DBa_scheduler_jobs and then create the jobs based on different schedule.

Thanks
Sanjay

• Original Message ---- From: Andrew Kerber <andrew.kerber_at_gmail.com> To: smishra_97_at_yahoo.com Cc: oracle-l_at_freelists.org Sent: Tuesday, January 15, 2008 4:22:00 PM Subject: Re: Scheduler Jobs

Why do you need to? select * from dba_scheduler_jobs should show you what you need to know.

On Jan 15, 2008 2:50 PM, Sanjay Mishra <smishra_97_at_yahoo.com > wrote:

Is there way to extract the DDL for Scheduler Job.  

TIA
Sanjay

Never miss a thing. Make Yahoo your homepage.

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 

--
http://www.freelists.org/webpage/oracle-l