SAP SQL Anywhere

Question

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

Accepted Answer

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.

SAP SQL Anywhere

Scheduled Event at last day of month skips 28. Feb. 2017

Follow this question

Related questions