Is there a way to check if an event is running? asked 25 Jan '11, 14:49 Jon Greisz |
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 Bruce Hay |
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 Volker Barth |
Sorry not enough detail. We need to check to see if another event is running when an event is kicked off and stop the new event. They are not the same event. It looks like there is a parameter within the same event to do this, but how about another event?