I created a job by using DBMS_JOB.SUBMIT(....);
when i say print jobno:
Now i want to run this job no 21 on every sunday morning 03:00:00 am. i tried it using dbms.next_date(sysdate,'sysdate+7);
but where to give sunday and time also??
Can any one help me how to put my job to run on every sunday ,please.
It would be very helpful if i can get sequence of steps. becuase i've to do it on production which in turn calls some other packages.
Click Here to Expand Forum to Full Width