Re: Scheduler Jobs

That may be the only way you have to do it.  Generate the ddl from the
dba_scheduler_jobs table.  It has everything you need, you just have to
generate it.

On Jan 15, 2008 10:11 PM, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:

> 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@xxxxxxxxx>
> To: smishra_97@xxxxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxx > wrote:
>
> >  Is there way to extract the DDL for Scheduler Job.
> >
> > TIA
> > Sanjay
> >
> > ------------------------------
> > Never miss a thing. Make Yahoo your 
> > homepage.<http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs>
> >
>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
>
> ------------------------------
> Never miss a thing. Make Yahoo your 
> homepage.<http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs>
>



-- 
Andrew W. Kerber

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

Other related posts: