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?