SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 SQL Server Agent - run executable
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

godistop1
Starting Member

14 Posts

Posted - 11/04/2013 :  12:43:18  Show Profile  Reply with Quote
I have created an console application that would like to run from SQL Server Agent. I get this error message, which not much help.
quote:
Date 11/4/2013 10:45:18 AM
Log Job History (ExcelOpenXMLTest)

Step ID 1
Server BNAWPUTIL03
Job Name ExcelOpenXMLTest
Step Name ExcelOpenXMLTest
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: OIARAD\sqlagent. The process could not be created for step 1 of job 0x7F1713AEF4237A48AED729EB7643B2DC (reason: The system cannot find the file specified). The step failed


I have put the exe in folder on the server, selected it through the prompts in creating a new job. Also, within the applicaton is calling an stored procedure and creating excel using OpenXML to network folder.

I have called tsql and ssis packages before through SQl Agent but this is the first an executable.

What am I doing wrong?

TG
Flowing Fount of Yak Knowledge

USA
6062 Posts

Posted - 11/04/2013 :  13:13:25  Show Profile  Reply with Quote
not sure but:
- double check the path of the executable in the command step
- make sure OIARAD\sqlagent has rights to the folder that the executable is in as well as any locations the application requires.

Be One with the Optimizer
TG
Go to Top of Page

godistop1
Starting Member

14 Posts

Posted - 11/04/2013 :  14:27:20  Show Profile  Reply with Quote
Does this part look right?
Using CmdExec:
\\W23?????\CPT Analysis Detail - RVU\CreateExcelOpenXML.exe
Go to Top of Page

TG
Flowing Fount of Yak Knowledge

USA
6062 Posts

Posted - 11/04/2013 :  16:08:28  Show Profile  Reply with Quote
Go this this folder (\\W23?????\CPT Analysis Detail - RVU) and see if this user has access: OIARAD\sqlagent

Be One with the Optimizer
TG
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000