1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| BEGIN
DBMS_SCHEDULER.CREATE_PROGRAM (
program_name => 'NOTEPAD',
program_action => 'C:\WINDOWS\NOTEPAD.EXE',
program_type => 'EXECUTABLE',
comments => 'Notepad');
END;
/
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'JOB_NOTEPAD_SCHEDULER',
program_name => 'NOTEPAD',
repeat_interval => 'FREQ=MINUTELY',
comments => 'Job lancement NOTEPAD');
END;
/
BEGIN
DBMS_SCHEDULER.ENABLE('NOTEPAD');
END;
/
BEGIN
DBMS_SCHEDULER.ENABLE('JOB_NOTEPAD_SCHEDULER');
END;
/ |
Partager