Is event running?

[Former Member]

Is there a way to check if an event is running?

[Former Member]

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?

[Former Member · Accepted solution]

If you are using 10.0.1 or later, you could use the following to check if a particular event is currently running:

if exists( select * from sa_conn_list(null,db_id()) 
    where connection_property('EventName', Number) = '<event_name>') then
    // event is running
end if;

[VolkerBarth]

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.