Is there a way to check if an event is running?
asked 25 Jan '11, 14:49
If you are using 10.0.1 or later, you could use the following to check if a particular event is currently running:
answered 25 Jan '11, 17:49
You can use sa_conn_info() to check for current connections.
Connections for events (like other internal connections) have high numbers (above 1 billion) and are named after the event.
So you might check that from within your event.
answered 25 Jan '11, 15:16