Oracle job is not running

Posted by Arsalan on Sep 05, 2017; 11:21am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Oracle-job-is-not-running-tp3400.html



Hello Arsalan,

I made the below oracle job which are not running automatically

if i run manually it working well, kindly guide what will be problem with this script

windows 2003
oracle 11g R2


BEGIN
       DBMS_SCHEDULER.CREATE_JOB
       (
       job_name            => 'merg_customs_data',
       job_type            => 'STORED_PROCEDURE', --'PLSQL_BLOCK',
       job_action          => 'merg_data',
       number_of_arguments => 0,
       start_date          => SYSTIMESTAMP,
       repeat_interval     =>'FREQ=DAILY; BYDAY=SAT,SUN,MON,TUE,WED,THU; BYHOUR=17',
       end_date            => NULL,
       enabled             => TRUE,
       auto_drop           => FALSE,
       comments            => 'This job merg data from d_customs_load to customs_import_data every night at 5:00PM'
       );
 END;
/

Thanks.