System Tray Notification - Fire when a new record is created in SQL Server

Question

Work in a support service. New tickets appear, and records are created in the SQL table, and they are dumped into a certain category, where any analyst can pick them up.
The front end does not notify analysts about the appearance of new tickets, so you need to constantly update the interface (browser) to see if new tickets arrive in the "Assign" folder.

I like to create a notifier (similar to something like GMail Notifier) ​​that is in the system tray.

Does anyone have any good starting points or possible fragments that could give me some enthusiasm to actually create some kind of identifier?

thank

Answer 1

Querying is one way to do this, but if you are using SQL Server 2005 or later, a more elegant solution is to use SQL Server Query Notifications. This allows you to specify a query (for example, "SELECT ID FROM Tickets") and receive notifications when the results change. There is a great tutorial on how to do this in CodeProject:

http://www.codeproject.com/KB/database/QueryNotifications.aspx

Answer 2

.NET, Timer "tick" 60 . Tick SQL / . , - , / , , / . "" . , BackGroundWorker, , SQL Server.

Answer 3

systray , , . , , "" 60 , , , .

# . , . , Java Java. - , .