Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1175
  • Last Modified:

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!
0
MrDavidThorn
Asked:
MrDavidThorn
  • 4
1 Solution
 
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
 
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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:
0
 
MrDavidThornAuthor Commented:
Found external URL guide to anwer my question
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now