External Job
811414Mar 12 2013 — edited Apr 6 2013I am doing a POC and and attempting to to execute the following external job on a windows installation of oracle
I am on 11g r2
BEGIN
-- Windows
DBMS_SCHEDULER.create_job(
job_name => 'win_command_job',
job_type => 'EXECUTABLE',
number_of_arguments => 3,
job_action => 'C:\windows\system32\cmd.exe',
auto_drop => FALSE,
enabled => FALSE);
DBMS_SCHEDULER.set_job_argument_value('win_command_job',1,'/c');
DBMS_SCHEDULER.set_job_argument_value('win_command_job',2,'mkdir');
DBMS_SCHEDULER.set_job_argument_value('win_command_job',3,'C:\TEMP\test_dir');
DBMS_SCHEDULER.set_attribute('win_command_job', 'credential_name', 'MY_CRED');
DBMS_SCHEDULER.enable('win_command_job');
END;
/
I have setup the credentials: exec dbms_scheduler.create_credential('my_cred','oracle','Test1234'); in the current schema
I am getting the following error
"EXTERNAL_LOG_ID="job_75255_1263",
ORA-27369: job of type EXECUTABLE failed with exit code: -10737409
"
Unfortunately, Windows error codes do not list this error...
I did a test by purposely not entering the correct password and when I did that I received the following
"EXTERNAL_LOG_ID="job_75244_1252",
ORA-27369: job of type EXECUTABLE failed with exit code: The storage control blocks were destroyed.
STANDARD_ERROR="Launching external job failed: Invalid username or password""
I have the OracleJobSchedulerORCL running... though when I stop it I get the same error..