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.

Hello.

If have the following Event defined in my Database

CREATE EVENT "dba"."CLEANUP"
SCHEDULE "CLEANUP" START TIME '06:00' ON ( 0 )
AT CONSOLIDATED
HANDLER
BEGIN 
    -- Process something 
END;

In Sybase Central the next planed execution is shown to be 31. March 2017.

alt text

I use 16.0.0.2213

asked 31 Jan '17, 12:31

Thomas%20Duemesnil's gravatar image

Thomas Dueme...
2.7k293965
accept rate: 17%

edited 31 Jan '17, 12:33


I can reproduce this V17 as well (using the wizard too) so it looks like a bug.

* I will check into this and let you know. *

For reference my test case SQL script looks like this

CREATE EVENT "DBA"."Hello Month End"
SCHEDULE "End_Of_Month" START TIME '06:00' ON ( 0 )
HANDLER
BEGIN
    Message '------------------------------------------------------------';
    Message '--                                                        --';
    Message '--   Hello Month End.  Did you forget somthing?           --';
    Message '--                                                        --';
    Message '------------------------------------------------------------';
END;
COMMENT ON EVENT "DBA"."Hello Month End" IS 'Hello Month End message';

One easy workaround would be to add a Feb 28th event for the same; to cover this hole in the schedule for these next 3 years. We should have it fixed before the next leap year I suspect.

permanent link

answered 31 Jan '17, 12:58

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

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

edited 31 Jan '17, 12:59

2

> should have it fixed

(31 Jan '17, 13:17) Breck Carter
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:

×261
×41
×6

question asked: 31 Jan '17, 12:31

question was seen: 1,827 times

last updated: 31 Jan '17, 13:18