SQL Agent – The step did not generate any output

For the past hour I’ve been racking my brain trying to figure out why SQL Agent kept throwing an error whenever I ran a job using CMDExec.  The job ran a very simple C# Console application.

Date 2/27/2012 11:57:14 AM
Log Job History (TEST JOB NAME)

Step ID 1
Server DBServer
Job Name Active Directory Empnum Update
Step Name Call Executable
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: USERNAME REMOVED. The step did not generate any output. Process Exit Code -2146232576. The step failed.

 

The problem was that I compiled the application using a .Net Framework that we don’t have on our database server.  To fix this go to your project’s properties and change the target framework to something that is installed on your DB server.

This is a very rookie mistake so hopefully this will save you a few minutes when you do the same dumb thing.

image

Leave a Reply

Your email address will not be published. Required fields are marked *


eight + 5 =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>