In SQL Anywhere 16 Sybase Central, where does the Event Properties "Next scheduled time:" value come from?
The displayed value seems to be the previous time rather than the next time.
I can't find any related column in the catalog colums.
asked 18 Feb, 09:27
It seems likely you may have already figured out where this info is coming from but here's the answer with links for others.
The SCJView uses the DB_EXTENDED_PROPERTY( ) function to display this. The portion of the select list in the query used to extract that looks like this:
cast("DB_EXTENDED_PROPERTY"('NextScheduleTime',"E"."event_name") as timestamp) as "next_schedule_time"
correlated on event_name.
I don't see the previous time behavior so that might need to be looked into.