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!
MrDavidThornAsked:
Who is Participating?
 
MrDavidThornAuthor Commented:
0
 
slightwv (䄆 Netminder) Commented:
0
 
Mark GeerlingsDatabase AdministratorCommented:
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?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
MrDavidThornAuthor Commented:
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.
0
 
MrDavidThornAuthor Commented:
I keep getting a 27370 error

"EXTERNAL_LOG_ID="job_71081_154589",
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.exe"

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)
0
 
MrDavidThornAuthor Commented:
Found external URL guide to anwer my question
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.