Home » SQL & PL/SQL » SQL & PL/SQL » Correct calender expression ? (oracle 10g,WINDOWS XP)
Correct calender expression ? [message #285960] Thu, 06 December 2007 03:29 Go to next message
lzfhope
Messages: 67
Registered: July 2006
Member
I want to create a job which will run on the last second of a month.
here is my Interval expression (Calender style):
FREQ=MONTHLY ,BYSECOND=-1
I do not know whether it is right or wrong.

In fact,i know if i use the following expression ,the job will run ok:
FREQ=MONTHLY,BYHOUR=23,BYSECOND=59.

IF "BYSECOND=-1" is Correct,then so about " BY HOUR=-1","BYMINUTE=-1" ?
Re: Correct calender expression ? [message #285987 is a reply to message #285960] Thu, 06 December 2007 04:25 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member

use EVALUATE_CALENDAR_STRING to check whether the interval expression is right or wrong.


regards,
Re: Correct calender expression ? [message #286245 is a reply to message #285987] Fri, 07 December 2007 00:27 Go to previous message
lzfhope
Messages: 67
Registered: July 2006
Member
Thank you! Razz
Previous Topic: Oracle Function to replace Oracle sequence
Next Topic: Assigning Number values to varchar2 columns and viceversa
Goto Forum:
  


Current Time: Fri Dec 02 20:55:47 CST 2016

Total time taken to generate the page: 0.11170 seconds