SAP SQL Anywhere

Question

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

Accepted Answer

5

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;

permanent link

answered 25 Jan '11, 17:49

Bruce Hay
2.6k●1●5●10
accept rate: 48%

flat view

Answer 2

3

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.

permanent link

answered 25 Jan '11, 15:16

Volker Barth
39.5k●355●539●811
accept rate: 34%

flat view

SAP SQL Anywhere

Is event running?

Follow this question

Related questions