August 27, 2002 at 3:57 am
On certain events (log file is getting full, a long running query has completed, ...) I want to raise events on my client machines. Which is best practice to do that? I don't want the clients to query the server every X-seconds if an event occured. So the event should definitivly be triggered from the server itself.
THX
Markus
August 27, 2002 at 4:21 am
The best way I know of where possible is to create an Alert then the response should be set to execute a job. The job can then in turn either write to a table in a notification database, which your apps will need to monitor periodically or, have it do a net send to all attached users either in general or using only the specific database in question. I have not tried this but it is a concept I was look at at one point.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
August 27, 2002 at 7:48 am
The only issue with the net send is that it will go the first place it finds the user. So if you have a user logged in to two different places, there's no guarantee the net send will get to the right place. That means you need to use the workstation, but since that can be set in the ODBC connection, that can cause problems, too.
Since what you are looking for is asynchronous communication, MSMQ may be a better fit than querying a table.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
August 28, 2002 at 12:27 am
I considered using an vb ocx called from within sql-server. The ocx will connect to the client via winsock an send a message "there is something on the sql-server you should look at". So I don't have the client to scan the server in intervalls.
What do you tink about that approach?
August 28, 2002 at 3:46 am
That I think would work just fine. There client thou has to have a listening port open to accept this new incoming connection. There are many ways to do what you want. The questions is the size of your environment, what issues will it cause, and is there a supportable infrastruture in place, or needs to be built.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
August 30, 2002 at 2:22 am
THX to you all for your Help.
Markus
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply