Get Data Moving 1
Results 1 to 3 of 3

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.

  3. #3
    hkandpal is offline Junior Member
    Join Date
    May 2017
    Posts
    1
    Rep Power
    0

    Need alerts when the CDC instance goes down

    Hi ,

    what is the table name in Oracle that we can check when the CDC instance stop.
    Is it the attrep_status table ? where is the table attrep_status table created in the source or target as I could not find it.
    thanks


    Last edited by hkandpal; 10-04-2018 at 11:38 AM.

Posting Permissions

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