Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

need a monitoring/watchdog script

Status
Not open for further replies.

Technokrat

Programmer
Jul 20, 2001
92
US
I need to create a script that will alert an operator when a trigger, stored proc, or scheduled process is missing?

We have run into problems where a replication is re-initialized and critical triggers end up being dropped/lost.

We want to create a script to monitor the process and notify somebody if a business critical item (trigger, stored proc, etc.) is lost/missing.

Anybody done anything like this?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top