Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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.4k364553825
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,521 times

last updated: 04 Apr '11, 09:52