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 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
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 Optimizer
TG |
 |
|
|
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\sqlagent
Be One with the Optimizer
TG |
|
|
|
|
|
|
SQL Server Agent - run executable