-
Hello All
This is just a quick one for you?
the NEXT_SEC parameter below, is the next time a job is scheduled to run? Right?
I think that the value that i originally set has changed?
By this i mean i set it for 7.30 & now its showing up as 2.30?
Any ideas?
Could this be possible?
Again many thanks for any help recieved
SELECT WHAT, JOB, LAST_DATE, NEXT_DATE, NEXT_SEC, BROKEN FROM USER_JOBS
Carpe Diem
-
You have submited your job with inapropriate job interval setting - you are experiencing "NEXT_DATE drifting". See
http://www.dbasupport.com/forums/sho...threadid=11185
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
hi Jurij
http://www.dbasupport.com/forums/sho...threadid=11185
This was a very good informative link . U have explained it in a very good and simple way . I had my doubts cleared .
Great !!!
Regards
Pravin
-
Hi Jurij
Thanks for the really informative link, i realize that a few weeks back the DB was unavailable till around 2 and that meant no updates until that time. So thanks Again for your help with this.
I have 4 jobs to re-submit, am i right in saying i have to delete them from DBMS job queue first before i re-submit?
& if this is the case. I wonder would you know the exact syntax for the deletion of the affected jobs?
Again Many thanks for your help so far, Your knowledge is most impressive.
Carpe Diem
-
You don't have to remove those 4 jobs if all you want to do is to resubmit them. You can use various DBMS_JOB procedures to change various parameters of your job, for example:
- DBMS_JOB.INTERVAL for changing the job's interval setting
- DBMS_JOB.NEXT_DATE for changing the time of job's next execution
- DBMS_JOB.WHAT for changing the contents of your job
- DBMS_JOB.CHANGE for changing all of the above options in one step
If you are uncomfortable with the above procedures then you can remove all your jobs using DBMS_JOB.REMOVE and then resubmit them with DBMS_JOB.SUBMIT or DBMS_JOB.ISUBMIT.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
hi Jurij
Thank you kindly for all your help.
I deleted the jobs & re-submitted them.
Everything should be ok for tomorrow
Regards & Many Thanks
Carpe Diem
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
|