Hi Guys,
I created a job by using DBMS_JOB.SUBMIT(....);
when i say print jobno:
JOBNO
------
21

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.