MrDavidThorn
asked on
Oracle Scheduler Job Credentials (Oracle version 11)
Hi Experts
I have created a scheduler job in Oracle, the Job executes a windows batch file. Im using local credentials. The O/S im using is Windows 2008 server.
When creating the credentials on SQL scheduler, I cant see where I need to enter the Windows AD account credentials - is the batch file executed with the Windows service account OracleJobSchedulerXE details?, or is the Windows credentials defined in the scheduler credentials? I cant see where the database credentials are stored / Windows credentials are stored against an oracle scheduler job!
I have created a scheduler job in Oracle, the Job executes a windows batch file. Im using local credentials. The O/S im using is Windows 2008 server.
When creating the credentials on SQL scheduler, I cant see where I need to enter the Windows AD account credentials - is the batch file executed with the Windows service account OracleJobSchedulerXE details?, or is the Windows credentials defined in the scheduler credentials? I cant see where the database credentials are stored / Windows credentials are stored against an oracle scheduler job!
Which tool are you using to create the schedule? Are you doing this in the database using the supplied package: DBMS_SCHEDULER? Or, are you doing this in OEM (Oracle Enterprise Manager)? Or, are you using a different tool/utility to enter this schedule?
ASKER
I dont know a lot about Oracle, but im using Oracle SQL developer and managing my connections from there.
I have created a credentials log in (With windows authentication details) but still having problems, I can add a "Program" object and the scheduler works - but if I point the scheduler at a batch file or script, it fails to load.
I have created a credentials log in (With windows authentication details) but still having problems, I can add a "Program" object and the scheduler works - but if I point the scheduler at a batch file or script, it fails to load.
ASKER
I keep getting a 27370 error
"EXTERNAL_LOG_ID="job_7108
ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:accessing login executable failed with status: 2
ORA-27301: OS failure message: The system cannot find the file specified.
ORA-27302: failure occurred at: sjsecl 1
ORA-27303: additional information: The system cannot find the file specified.
"
My job action is "C:\Windows\System32\cmd.e
I have no parameters mapping to a bat file (I could add them but figgured - just to get a sucess on the cmd.exe would be a good start)
"EXTERNAL_LOG_ID="job_7108
ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:accessing login executable failed with status: 2
ORA-27301: OS failure message: The system cannot find the file specified.
ORA-27302: failure occurred at: sjsecl 1
ORA-27303: additional information: The system cannot find the file specified.
"
My job action is "C:\Windows\System32\cmd.e
I have no parameters mapping to a bat file (I could add them but figgured - just to get a sucess on the cmd.exe would be a good start)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Found external URL guide to anwer my question
http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/d_sched.htm#ARPLS72292