|
-
Jurij/Julian ,
Here again i'm pasting some more results after i set the job as you mentioned. Here i'm confused like, next_date is showing as 09-JUL-02, which is today. But interval is showing as correct . Can you please clarify??
SQL> select INTERVAL from user_jobs where job=172;
INTERVAL
--------------------------------------------------------------------------------
NEXT_DAY(TRUNC(SYSDATE),'SUNDAY')+3/24
SQL> select NEXT_DATE,NEXT_SEC from user_jobs where job=172;
NEXT_DATE NEXT_SEC
--------- --------
09-JUL-02 03:59:06
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
|