|
-
I'm sorry jurij, forgot to put a commit there. Here is the code i used with commit , but still getting the same out put.
SQL> variable jobno number
SQL> begin
2 DBMS_JOB.SUBMIT(:jobno, 'CALL_WEEKLY;',sysdate,
3 'NEXT_DAY(TRUNC(SYSDATE),''SUNDAY'')+3/24');
4 commit;
5 end;
6 /
PL/SQL procedure successfully completed.
SQL> print jobno
JOBNO
----------
41
SQL> select THIS_DATE,THIS_SEC,NEXT_DATE, NEXT_SEC,INTERVAL from user_jobs where job=41;
THIS_DATE THIS_SEC NEXT_DATE NEXT_SEC
--------- -------- --------- --------
INTERVAL
--------------------------------------------------------------------------------
09-JUL-02 05:01:51 09-JUL-02 05:01:47
NEXT_DAY(TRUNC(SYSDATE),'SUNDAY')+3/24
Here it's still showing next_date as today's date only. Did i do any mistake again?? Please help me
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
|