SQL Operators

JamesFJamesF Posts: 2 New member
in SQL Search
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. 
Tagged:
· Share on Twitter

Answers

  • Alex BAlex B Posts: 1,158 Diamond 4
    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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.