JOB SCHEDULER [message #555097] |
Mon, 21 May 2012 06:32 |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hi All,
I am trying to create the below SCHEDULER for the case of "EXECUTING BATCH FILE AT 9.15,9.30,9.45,10.00 EVERY DAY".
Have I created correctly or not.
please confirm
DECLARE
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'TRIGGERING_TICKER',
job_type => 'EXECUTABLE',
job_action => 'D:\Project\DBase\SQL\TICKER\CMD',
start_date => '21-May-12 9.00.00 AM',
repeat_interval => 'FREQ=weekly;BYDAY=MON,TUE,WED,THU,FRI;BYhour=9;byminute=15,30,45,60',
enabled => TRUE,
comments => 'This scheduler for Running the TICKER FILE');
END;
Regards
Muktha
|
|
|
|
|
|
|