|
-
To jurij & Julian
Jurij/Julian,
I tried with your code, and here i'm pasting the same, please look at these:
SQL> variable jobno number
SQL> begin
2 DBMS_JOB.SUBMIT(:jobno, 'CALL_WEEKLY;',
3 sysdate,
4 'NEXT_DAY(TRUNC(SYSDATE),''SUNDAY'')+3/24');
5 end;
6 /
PL/SQL procedure successfully completed.
SQL> print jobno
JOBNO
----------
172
SQL> select JOB,SCHEMA_USER,LAST_DATE,NEXT_DATE,NEXT_SEC from user_jobs;
JOB SCHEMA_USER LAST_DATE NEXT_DATE NEXT_SEC
---------- ------------------------------ --------- --------- --------
169 CMS2ADM 09-JUL-02 15:28:54
170 CMS2ADM 09-JUL-02 16:37:53
90 CMS2ADM 08-JUL-02 09-JUL-02 10:35:25
172 CMS2ADM 09-JUL-02 03:59:06
SQL> select sysdate from dual;
SYSDATE
---------
09-JUL-02
SQL> select NEXT_DATE,NEXT_SEC,THIS_DATE,THIS_SEC,INTERVAL from user_jobs
2 where job=172;
NEXT_DATE NEXT_SEC THIS_DATE THIS_SEC
--------- -------- --------- --------
INTERVAL
--------------------------------------------------------------------------------
09-JUL-02 03:59:06
NEXT_DAY(TRUNC(SYSDATE),'SUNDAY')+3/24
Here, i'm confused, NEXT_DATE,NEXT_SEC is showing as the date and time at which i created the job. Can you please tell me how to check it up when my job is going to fire again ?? as per we set in the code???
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
|