I have a couple of jobs that will make a SQL call and then check to see if the output is has any results and then create an email with the output. In order to do this now I have to create a conditional that looks at the specific task output. It's a pain in the butt to do this for each of the jobs. My conditionals is cluttered with all of items that can only work on a single task. (as a side note, it would be nice if you could mark a conditional not to be global, but just for a task)
It would seem like the 'notifications' part of the job or task would be idea, but it doesn't have a variable look at the active job's output.
Am I missing something? Is there an easier way to do this?