on 2011 Apr 01 3:49 PM
Event details such as "running", "enabled", and "next scheduled time" can be monitored within sybase central. Is there a way to see these "fields", i.e. through a system table or otherwise, through iSQL?
Appreciate any help.
Request clarification before answering.
I don't think there is a single system table/view that displays all these informations.
However, I expect all this can be queried and calculated from
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To get the next scheduled time for an event, use:
select db_extended_property('NextScheduleTime','<event-name>')
Use the following to list running events:
select connection_property('EventName',number) as evtname
from dbo.sa_conn_list()
where evtname <> ''
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
52 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.