Oracle job scheduling?

[Barabas]

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

[jmodic]

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

[pravin]

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

[Barabas]

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.

[jmodic]

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.

[Barabas]

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