Is it possible to obtain DBMS_SCHEDULER log id from within program being scheduled

Home -> Community -> Usenet -> c.d.o.server -> Is it possible to obtain DBMS_SCHEDULER log id from within program being scheduled

From: Neil <neil.emery_at_ds-s.com>
Date: 27 May 2005 02:35:59 -0700
Message-ID: <1117186559.049081.236110@f14g2000cwb.googlegroups.com>

Hi.

As above,

basically what i am trying to do is attach output files to a shceduled program using the DBMS_SCHEDULER package. Within the program being executed i want to output log file and output file information, attached to the Job in the scheduler, so that using the USER_SCHEDULER_JOB_LOG view i can drill into the files produced by the procedure (i am using utl_file to produce these files) being executed.

Any help greatly appreciated

Cheers,

Neil

Version Info

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production NLSRTL Version 10.1.0.2.0 - Production

OS Windows Server 2003 Received on Fri May 27 2005 - 04:35:59 CDT