Post reply

SQL Replication alerting

  • March 24, 2014 at 9:34 am

    #291269

    I have set up database mail on a server which is working fine and I am getting alerting when SQL jobs finish.

    I get alerted when the snapshot job is being executed, which is fine, but i also need to know when the snapshot has been applied to the subscriber.

    I went into replication monitor, alerts and set it up in there for agent failure, agent retry, agent success. But this didn't do the trick.

    Any ideas?

  • March 24, 2014 at 10:40 am

    #1699608

    SQLSteve (3/24/2014)

    I have set up database mail on a server which is working fine and I am getting alerting when SQL jobs finish.

    I get alerted when the snapshot job is being executed, which is fine, but i also need to know when the snapshot has been applied to the subscriber.

    I went into replication monitor, alerts and set it up in there for agent failure, agent retry, agent success. But this didn't do the trick.

    Any ideas?

    Snapshots are applied via a SQL job - correct?

    So why not simply set up the snapshot job to notify you by email or page when the job completes (that will let you know whether the job succeeds or fails)?

    Thanks

    John.

  • March 24, 2014 at 12:10 pm

    #1699651

    Alerts set up via the manager don't always set up correctly (at least in my experience) so I suggest scripting them out and ensuring you have the @shouldalert set to 1

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply