Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
godistop1
Starting Member
14 Posts |
 Posted - 2013-11-04 : 12:43:18
|
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 AMLog Job History (ExcelOpenXMLTest)Step ID 1Server BNAWPUTIL03Job Name ExcelOpenXMLTestStep Name ExcelOpenXMLTestDuration 00:00:00Sql Severity 0Sql Message ID 0Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageExecuted 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
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-11-04 : 13:13:25
|
| 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 OptimizerTG |
 |
|
|
godistop1
Starting Member
14 Posts |
Posted - 2013-11-04 : 14:27:20
|
| Does this part look right?Using CmdExec:\\W23?????\CPT Analysis Detail - RVU\CreateExcelOpenXML.exe |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-11-04 : 16:08:28
|
| Go this this folder (\\W23?????\CPT Analysis Detail - RVU) and see if this user has access: OIARAD\sqlagentBe One with the OptimizerTG |
|
|
|
|
|
|
SQL Server Agent - run executable