Home » RDBMS Server » Enterprise Manager » Oracle Schedule daily, between two times
Oracle Schedule daily, between two times [message #252871] Fri, 20 July 2007 07:57 Go to next message
yamon
Messages: 22
Registered: July 2006
Junior Member
Hi,

I can set up an Oracle Schedule with Enterprise Manager to run each day at a specified time, but I am unsure about the best way of specifying a schedule to run each day, every hour between two times (ie 2am to 10pm). Having read several documents, am I right in assuming the only way of doing this is to create a job and specify the parameters FREQ=DAILY; BYHOUR=2,3,4...20,21,22 etc for each hour of the day?

I was wondering if there was a different method for this?

Many thanks for any advice.

Yamon.
Re: Oracle Schedule daily, between two times [message #252883 is a reply to message #252871] Fri, 20 July 2007 08:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
FREQ=HOURLY;BYMINUTE:0

Regards
Michel
Re: Oracle Schedule daily, between two times [message #252888 is a reply to message #252883] Fri, 20 July 2007 08:40 Go to previous messageGo to next message
yamon
Messages: 22
Registered: July 2006
Junior Member
Hi Michel,

How would I specify it should only be between 2am and 10pm?

Thanks,
Yamon
Re: Oracle Schedule daily, between two times [message #252889 is a reply to message #252888] Fri, 20 July 2007 08:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry, didn't see it.
So, I don't see other way than listing each hour.

Regards
Michel

[Updated on: Fri, 20 July 2007 10:51]

Report message to a moderator

Re: Oracle Schedule daily, between two times [message #252895 is a reply to message #252889] Fri, 20 July 2007 09:17 Go to previous messageGo to next message
yamon
Messages: 22
Registered: July 2006
Junior Member
I couldnt see any other way either, just wanted to check.

Thanks Michel.
Re: Oracle Schedule daily, between two times [message #253035 is a reply to message #252895] Sat, 21 July 2007 14:01 Go to previous message
krblr
Messages: 24
Registered: April 2007
Location: MD
Junior Member

Sorry Yamon,
I came here to look for an answer myself ...
Previous Topic: EM NOT WORKING
Next Topic: 10gDBConsole Service Creation on Windows
Goto Forum:
  


Current Time: Fri Mar 29 10:47:33 CDT 2024