|
-
Hi
I am trying to submit a job to the job queue and the code is below
VARIABLE JOBNO NUMBER;
BEGIN
DBMS_JOB.SUBMIT(:JOBNO,
'PACKAGE NAME;', SYSDATE,
'NEXT_DATE(TRUNC(SYSDATE),"MONDAY") + 09/24');
END;
I am gettingt he message that the NEXT_DATE line is inappropriate
I want the package to run, once a week at 09:00 on a Monday morning irregardless of when it was last run
Can anyone give me any pointers ??
Cheers
:-(
:p :p :p
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
|