Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: DDL for scheduler jobs?
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
![]() |
![]() |