BEGIN
DBMS_SCHEDULER.CREATE_CREDENTIAL (
credential_name => 'CREDENCIAL_PRUEBA',
username => 'TONYROJAS',
password => 'ABC',
windows_domain => 'SYSTEM'
);
END;
BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'PRUEBA',
job_type => 'EXECUTABLE',
job_action => 'C:\WINDOWS\SYSTEM32\CMD.EXE',
number_of_arguments => 2,
start_date => SYSTIMESTAMP,
repeat_interval => 'FREQ=DAILY; BYHOUR=23',
enabled => FALSE,
auto_drop => FALSE,
comments => 'Job para realizar backup diario'
);
-- EJECUTAR COMANDOS DENTRO DEL SIMBOLO DEL SISTEMA
DBMS_SCHEDULER.set_job_argument_value ('PRUEBA', 1, '/C');
DBMS_SCHEDULER.set_job_argument_value ('PRUEBA', 2, 'C:\BackupOracle\creararchivo.cmd');
** DBMS_SCHEDULER.set_attribute('PRUEBA', 'credential_name', 'CREDENCIAL_PRUEBA');**
DBMS_SCHEDULER.enable('PRUEBA'); `
END;
BEGIN DBMS_SCHEDULER.run_job('PRUEBA'); END;