--dbms job run every sunday for proposed annual goal report
dbms_job.submit(job => X,
what => 'wkly_proposed_goal_improve_prc' ,
next_date => next_day(trunc(sysdate),'SUN'),
interval => 'next_day(trunc(sysdate),''SUN'')',
no_parse => true);
It said failures 17 and I know the job is not running
I want the job to run every sunday. Can someone help me?