BEGIN
DBMS_SCHEDULER.create_job ('FILECOPY_DB_JB',
job_action => 'C:\WINDOWS\SYSTEM32\CMD.EXE',
number_of_arguments => 3,
job_type => 'executable',
enabled => FALSE);
DBMS_SCHEDULER.set_job_argument_value ('myjob', 1, '/q');
DBMS_SCHEDULER.set_job_argument_value ('myjob', 2, '/c');
DBMS_SCHEDULER.set_job_argument_value ('myjob', 3, 'D:\xxtest\tt\fileCopy.bat');
DBMS_SCHEDULER.enable ('FILECOPY_DB_JB');
END;
/
No comments:
Post a Comment