Re: q: using ADDITIONAL_INFO field in DBMS_SCHEDULER

agonenil_at_gmail.com wrote:

> hi , does anyone knows on a way to populate the field ADDITIONAL_INFO
> in the view of USER_SCHEDULER_JOB_RUN_DETAILS ?

I believe it is populated from the COMMENTS parameter of DBMS_SCHED.CREATE_JOB. DBMS_SCHEDULER.CREATE_JOB (

    job_name             IN VARCHAR2,
    job_type             IN VARCHAR2,
    job_action           IN VARCHAR2,
    number_of_arguments  IN PLS_INTEGER              DEFAULT 0,
    start_date           IN TIMESTAMP WITH TIME ZONE DEFAULT NULL,
    repeat_interval      IN VARCHAR2                 DEFAULT NULL,
    end_date             IN TIMESTAMP WITH TIME ZONE DEFAULT NULL,
    job_class            IN VARCHAR2                 DEFAULT 
'DEFAULT_JOB_CLASS',
    enabled              IN BOOLEAN                  DEFAULT FALSE,
    auto_drop            IN BOOLEAN                  DEFAULT TRUE,
    comments             IN VARCHAR2                 DEFAULT NULL);

But I am not at a place where I can verify this for you.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)