Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

External Job

811414Mar 12 2013 — edited Apr 6 2013
I 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..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 4 2013
Added on Mar 12 2013
9 comments
1,427 views