SQL Operators

JamesF

I was hoping to search all SQL operators for a certain email address as our domains are changing.  The only entry I see under server objects is 'Jobs'.  I can query separately but was hoping to have all results in one place. 

Alex B

Hi @JamesF,

Unfortunately, the search for the Jobs object is done on the job name, step names, and T-SQL content of the steps - e.g.:

testJobFailAlert is a job with 1 steps
Step 1: onlyOneStep
SELECT 1;

So you will need to use the other method to audit the email addresses for the operators.

Kind regards,
Alex