Re: Scheduler Jobs

From: Sanjay Mishra <>
Date: Tue, 15 Jan 2008 20:11:03 -0800 (PST)
Message-ID: <>


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.


  • Original Message ---- From: Andrew Kerber <> To: Cc: 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 < > wrote:

Is there way to extract the DDL for Scheduler Job.  


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.;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 

Received on Tue Jan 15 2008 - 22:11:03 CST

Original text of this message