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.
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.