This content has been marked as final. Show 2 replies
1 person found this helpful
user5716448 wrote:consider issuing COMMIT so it can be seen by other sessions.
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.
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;
Edited by: user5716448 on 01-Nov-2012 07:39
Disppears from al_scheduler_jobs as runs just once - ashow in audit table