Reschedule job outside of OEM [message #288500] |
Mon, 17 December 2007 16:29 |
pputh
Messages: 13 Registered: December 2007 Location: Sacramento
|
Junior Member |
|
|
Hi,
I am asked to schedule an offline backup job to run every third Saturday of the month. I don't want to manually reschedule the job for every month; thus, I am attempting to write a script to update the underlying job table to change the job date and resubmit the job. I am not sure how to submit OEM job outside of OEM. Is anyone aware of submitting job outside of OEM? Or does anyone how a suggestion on who to schedule a job to run as I describe above?
Thanks in advance,
|
|
|
|
|
Re: Reschedule job outside of OEM [message #288779 is a reply to message #288519] |
Tue, 18 December 2007 11:36 |
pputh
Messages: 13 Registered: December 2007 Location: Sacramento
|
Junior Member |
|
|
Thanks Arju, but I do not want to use Window scheduler I like to keep everything OEM.
Looking at the resource you provided, it may work. I will try it.
Thanks,
|
|
|
Re: Reschedule job outside of OEM [message #288820 is a reply to message #288500] |
Tue, 18 December 2007 16:04 |
pputh
Messages: 13 Registered: December 2007 Location: Sacramento
|
Junior Member |
|
|
Since DBMS_SCHEDULER is not 9i package, I am trying DBMS_JOB instead; however, I not sure if I could change the schedule for job that I created/submitted via OEM.
|
|
|