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.
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?