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

Neil wrote:
> 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

Will querying DBA_SCHEDULER_WINDOW_LOG or DBA_SCHEDULER_RUNNING_JOBS do it for you?

-- 
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)