How can we help you today? How can we help you today?

SQL Operators

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.
JamesF
0

Comments

1 comment

Sort by
  • 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
    Alex B
    0

Add comment

Please sign in to leave a comment.