What are the challenges you face when working across database platforms? Take the survey
Options

SQL Operators

JamesFJamesF Posts: 2 New member
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:

Answers

  • Options
    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?
Sign In or Register to comment.