Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I create an alert condition within an SP?
Message
From
21/11/2002 16:32:37
Margaret Gillon
Chromalloy
Anaheim, California, United States
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
How do I create an alert condition within an SP?
Miscellaneous
Thread ID:
00725468
Message ID:
00725468
Views:
45
I have a SP that checks datetime stamps on 12 tables. I am scheduling the SP to run every half hour. If the most recent datetime stamp is more than 30 minutes old I would like the SP to trigger an alert that would email me. How do I write a Stored Procedure that can do this?
Next
Reply
Map
View

Click here to load this message in the networking platform