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 '17, 09:27

Breck%20Carter's gravatar image

Breck Carter
32.5k5397241050
accept rate: 20%


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.

permanent link

answered 21 Feb '17, 08:43

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
7.3k35107
accept rate: 32%

edited 06 Mar '17, 10:54

If you are working with a 10.0.0 or early 10.0.1 server it may be possible you might see a missed schedule that way. Engineering Change #480547 was fixed in 10.0.1 bld#3562 and all more recent releases. The issue there was if the schedule's 'start time' included milliseconds, it could fail to 'fire'.

Otherwise, see what happens when you revert/change the public/dba timestamp_format. If that has any impact you might want to compare your results to the behavior describe in Engineering Change 625647.

(21 Feb '17, 08:50) Nick Elson S...
1

What does the [NextScheduleTime][2] syntax mean?

(05 Mar '17, 09:41) Breck Carter

That was supposed to be a link inside of a code formatted section. Failing that I have corrected the original answer.

(06 Mar '17, 10:55) Nick Elson S...
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:

×3

question asked: 18 Feb '17, 09:27

question was seen: 1,477 times

last updated: 06 Mar '17, 10:55