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.

asked 01 Apr '11, 14:49

zippidydo's gravatar image

zippidydo
377151521
accept rate: 0%


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

  • sysevent ("enabled")
  • sysschedule ("start_time", "start_date" etc.) - but I guess you would have to calculate the next scheduled time yourself based on these columns and the current time
  • sa_conn_info - a procedure that lists all current connections and as such, will include currently running events. AFAIK events will show up with their name as connection name and with a connection ID value > 1.000.000.000.
permanent link

answered 02 Apr '11, 15:15

Volker%20Barth's gravatar image

Volker Barth
40.1k361549819
accept rate: 34%

Comment Text Removed
Comment Text Removed

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 <> ''
permanent link

answered 04 Apr '11, 09:52

Bruce%20Hay's gravatar image

Bruce Hay
2.6k1510
accept rate: 48%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×41

question asked: 01 Apr '11, 14:49

question was seen: 2,371 times

last updated: 04 Apr '11, 09:52