2 Replies Latest reply: Nov 1, 2012 9:47 AM by user5716448 RSS

    dbms_scheduled job not showing in all_scheduler_jobs 11.2.0.3

    user5716448
      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
          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
            Found answer

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

            al_scheduler_jobn_run_details