The forum is currently being migrated to a new host. While the migration happens, the old server is still available. Once the new machine is ready, I will copy the database to the new machine. Feel free to ask and answer questions in the meantime.

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
31.3k5036891009
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:

×2

question asked: 18 Feb '17, 09:27

question was seen: 1,014 times

last updated: 06 Mar '17, 10:55