Home » RDBMS Server » Enterprise Manager » Reschedule job outside of OEM (9i, Window 2003 server)
Reschedule job outside of OEM [message #288500] Mon, 17 December 2007 16:29 Go to next message
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 #288518 is a reply to message #288500] Mon, 17 December 2007 22:15 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Windows machine has its own scheduler(scheduler task) I think. You can take help from that.
Re: Reschedule job outside of OEM [message #288519 is a reply to message #288500] Mon, 17 December 2007 22:19 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Also I think you can use DBMS_SCHEDULER.CREATE_SCHEDULER procedure.
Here is the link ,

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_sched.htm#i1010076
Re: Reschedule job outside of OEM [message #288779 is a reply to message #288519] Tue, 18 December 2007 11:36 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: EM console error
Next Topic: Scheduling backup
Goto Forum:
  


Current Time: Thu Mar 28 09:06:07 CDT 2024