Is there a way to check for sql job execution status?

Content Authoring
1

Hi,

I have maintenance tasks and other jobs running on my sql servers. Is there a way to use an analysis to get all the jobs set up on a given sql server, their status and last running time?
I’m hoping it would save me from going through all the servers manually, as well as keeping an eye on the servers to make sure no one adds a job without my knowledge.

Thanks in advance!

2

Pipe the output of the SQL execution to a log. Use analysis and/or task relevance to report or target based on the output.

As an example, after certain installs are complete, I run a validation SQL that is output to a log file. I have a ‘continue if’ statement in my install task that parses the SQL log for success indicators. That way if they aren’t present, the task action flags as failed so that I can investigate.