Load Ingest Data
Results 1 to 2 of 2

Thread: Need alerts when the CDC instance goes down

  1. #1
    Nagesam is offline Junior Member
    Join Date
    Mar 2015
    Posts
    1
    Rep Power
    0

    Need alerts when the CDC instance goes down

    Hi Team,

    We are using CDC tool in our dev environment. we have created few instances to capture the modifications done at source databases. All are working fine.

    Now, we have one requirement that, when the CDC instance goes STOP, LOGGER, ABORTED etc. we should get alter message to know the status of the CDC instance.

    Can you please help, is there any way to get these alerts.

    Thanks.

  2. #2
    mwysocki is offline Junior Member
    Join Date
    Mar 2015
    Posts
    2
    Rep Power
    0
    Very easy. The status of CDC instances is recorded in their respective CDC DBs. Just write a stored procedure to query the status table and throw an error when status <> 'RUNNNG'. Then schedule the procedure in SQL Server Agent and set it to send an email on error.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •