2-i am trying to create the following job to run every hour
BEGIN
DBMS_SCHEDULER.create_job (
JOB_NAME => 'BACKUP_JOB',
JOB_TYPE => 'EXECUTABLE',
JOB_ACTION => 'c:\backup.bat',
START_DATE => trunc(SYSDATE+1/24,'HH'),
REPEAT_INTERVAL => 'FREQ=HOURLY;INTERVAL=1',
COMMENTS => 'Logical backup');
END;
My first question is whether it supports .bat executables
If it does then can anybody help me in this regard?
thanx in advance
Bookmarks