OraFAQ Forum: Enterprise Manager » Oracle Schedule daily, between two times

Home » RDBMS Server » Enterprise Manager » Oracle Schedule daily, between two times

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Schedule daily, between two times [message #252871]

Fri, 20 July 2007 07:57

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.

Report message to a moderator

Re: Oracle Schedule daily, between two times [message #252883 is a reply to message #252871]

Fri, 20 July 2007 08:26

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

FREQ=HOURLY;BYMINUTE:0

Regards
Michel

Report message to a moderator

Re: Oracle Schedule daily, between two times [message #252888 is a reply to message #252883]

Fri, 20 July 2007 08:40

yamon
Messages: 22
Registered: July 2006

Junior Member

Hi Michel,

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

Thanks,
Yamon

Report message to a moderator

Re: Oracle Schedule daily, between two times [message #252889 is a reply to message #252888]

Fri, 20 July 2007 08:46

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

yamon
Messages: 22
Registered: July 2006

Junior Member

I couldnt see any other way either, just wanted to check.

Thanks Michel.

Report message to a moderator

Re: Oracle Schedule daily, between two times [message #253035 is a reply to message #252895]

Sat, 21 July 2007 14:01

krblr
Messages: 24
Registered: April 2007
Location: MD

Junior Member

You are kidding right?

There we go again

Sorry Yamon,
I came here to look for an answer myself ...

Report message to a moderator

Previous Topic:	EM NOT WORKING
Next Topic:	10gDBConsole Service Creation on Windows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 16:53:01 CST 2024