Event Based Alerts
-
We are using SQL Server 2000 for a online data capturing system which is expected to send alerts to the PCs based on the EVENTS-"Deviation from the threshold value of the data field". As such we have stored procedured which is scheduled for a time ,which inturn sends alert to the PC.But we want it happend based on the Events not on the time schedule,can you provide your expert comment/solution on this.
-
In SQL 2000 these "Events" would be triggers.
--------------------
Colt 45 - the original point and click interface
-
Can you elaborate on this,how can i get this done, pls advise
-
Look up "Triggers" in your local copy of Books Online, or you can also view the information here,
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_1tup.asp
--------------------
Colt 45 - the original point and click interface -
i shall try this and get back to you for any further help, thanks
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply