-
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.
PNRDBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|