|
Every Monday, Wednesday and Friday at 6:00
AM |
‘trunc(least(next_day(sysdate, ‘‘monday’’),
next_day(sysdate, ‘‘wednesday’’), next_day(sysdate, ‘‘friday’’)))
+ (6/24)’
‘trunc(least(next_day(systimestamp, ‘‘monday’’),
next_day(systimestamp, ‘‘wednesday’’), next_day(systimestamp, ‘‘friday’’)))
+ (6/24)’
‘trunc(least(next_day(sysdate,’’monday’’),
next_day(sysdate, ‘‘wednesday’’), next_day(sysdate, ‘‘friday’’)))
+ interval ‘‘6’’ hour’
‘trunc(least(next_day(systimestamp, ‘‘monday’’),
next_day(systimestamp, ‘‘wednesday’’), next_day(systimestamp, ‘‘friday’’)))
+ interval ‘‘6’’ hour’
‘freq=weekly; byday=mon,wed,fri; byhour=6;
byminute=0; bysecond=0;’
Next Run Date: 02-JAN-2004 06:00:00
Next Run Date: 05-JAN-2004 06:00:00
Next Run Date: 07-JAN-2004 06:00:00
Next Run Date: 09-JAN-2004 06:00:00
Next Run Date: 12-JAN-2004 06:00:00 |
|
First Monday of each quarter |
‘next_day(add_months(trunc(sysdate, ‘‘q’’),
3), ‘‘monday’’)’
‘next_day(add_months(trunc(systimestamp,
‘‘q’’), 3), ‘‘monday’’)’
‘freq=monthly; bymonth=1,4,7,10; byday=1mon’
Next Run Date: 05-APR-2004 00:00:00
Next Run Date: 05-JUL-2004 00:00:00
Next Run Date: 04-OCT-2004 00:00:00
Next Run Date: 03-JAN-2005 00:00:00
Next Run Date: 04-APR-2005 00:00:00 |
