This discussion is archived
2 Replies Latest reply: Nov 1, 2012 7:47 AM by user5716448 RSS

dbms_scheduled job not showing in all_scheduler_jobs 11.2.0.3

user5716448 Explorer
Currently Being Moderated
Hi,

Have created a dbms_scheduled job to try an drun immediately once only.

Not running and not seeing listed in all_scheduler_jobs.

No error shown when try and create the job.

Uiasng 11.2.0.3
BEGIN
  -- Job defined entirely by the CREATE JOB procedure.
  DBMS_SCHEDULER.create_job (
    job_name        => 'TRANSF_DATA_TO_ARCHIVE_AND_PIX',
    job_type        => 'PLSQL_BLOCK',
    job_action      => 'BEGIN datawarehouse_transfer_data.look_for_data; END;',
    start_date      => SYSTIMESTAMP,
    repeat_interval => null,
    end_date        => NULL,
    enabled         => TRUE,
    comments        => 'Job defined entirely by the CREATE JOB procedure.');
END; 
Any ideas?

Thanks

Edited by: user5716448 on 01-Nov-2012 07:39
  • 1. Re: dbms_scheduled job not showing in all_scheduler_jobs 11.2.0.3
    sb92075 Guru
    Currently Being Moderated
    user5716448 wrote:
    Hi,

    Have created a dbms_scheduled job to try an drun immediately once only.

    Not running and not seeing listed in all_scheduler_jobs.

    No error shown when try and create the job.

    Uiasng 11.2.0.3
    BEGIN
    -- Job defined entirely by the CREATE JOB procedure.
    DBMS_SCHEDULER.create_job (
    job_name        => 'TRANSF_DATA_TO_ARCHIVE_AND_PIX',
    job_type        => 'PLSQL_BLOCK',
    job_action      => 'BEGIN datawarehouse_transfer_data.look_for_data; END;',
    start_date      => SYSTIMESTAMP,
    repeat_interval => null,
    end_date        => NULL,
    enabled         => TRUE,
    comments        => 'Job defined entirely by the CREATE JOB procedure.');
    END; 
    Any ideas?

    Thanks

    Edited by: user5716448 on 01-Nov-2012 07:39
    consider issuing COMMIT so it can be seen by other sessions.
  • 2. Re: dbms_scheduled job not showing in all_scheduler_jobs 11.2.0.3
    user5716448 Explorer
    Currently Being Moderated
    Found answer

    Disppears from al_scheduler_jobs as runs just once - ashow in audit table

    al_scheduler_jobn_run_details

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points