Re: DDL for scheduler jobs?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Wed, 24 Oct 2007 07:50:50 -0700
Message-ID: <1193237450.467696.150150@q5g2000prf.googlegroups.com>

On Oct 23, 7:47 pm, "D.T." <dejan.topalo..._at_gmail.com> wrote:
> Is there any way to get/extract DDL statement for scheduler jobs? I
> tried with dbms_metadata.get_ddl, but I'm getting ORA-31604.
>
> Thanks for any advice
>
> D.T.

You use the dbms_job or with 10g the dbms_scheduler package(s) to define jobs to Oracle.

You can use the dba_scheduler views especially dba_scheduler_jobs to extract the job information.

HTH -- Mark D Powell -- Received on Wed Oct 24 2007 - 09:50:50 CDT