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:

×260
×41
×6

question asked: 31 Jan '17, 12:31

question was seen: 1,728 times

last updated: 31 Jan '17, 13:18