This is a fairly simple one once you’ve seen it, but then so are lots of things 🙂. Let’s say you have a failed SQL Server job.

Here is our job that will fail:

Pic1

Then we run it and it fails!

And when we click on the error message we get:

Well that’s not terribly useful. So let’s go look at the job history and see what we see.

Well, we can see that this job failed, when it ran, and what the job name is. At the bottom is the detail information. No error though! Well, do you see that + next to the red X? Click on that and we start to get somewhere:

Now we have what we need! First we can see which step failed, and the step number. Then if you look in the detail section at the bottom we have some really useful information. Who ran this step, and what we’ve been looking for the whole time. The error. Note: If this is an SSIS step then you get the SSIS output which while it will have the error in it is going to be as cryptic as ever.

Filed under: Microsoft SQL Server, Problem Resolution, SQL Agent Jobs, SQLServerPedia Syndication Tagged: microsoft sql server, problem resolution, SQL Agent Jobs