I have a job that sends an email to an operator (which contains a list of emails within it) upon complexion.
Some of these people that are on that list are the developers who build everything in that job.
I am the DBA but I am also in the list.
Is there a way to make this job send an email to those guys upon complexion, and to the DBAs only if the job fails?
So, upon complexion of the job, which has 4 steps, the developers will always get an email, (the job is scheduled to run every day), and if (by any reason) the job fails, the developers AND the DBAs will get and email.