The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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
362151521
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
29.3k287438645
accept rate: 32%

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:

×34

question asked: 01 Apr '11, 14:49

question was seen: 939 times

last updated: 04 Apr '11, 09:52