#12707: Sybase Anywhere 16 -> Create event -> new option FOR ALL |

ivangron reported 2014-11-11T22:57:35Z · last modified 2014-11-27T18:55:51Z

Sybase Anywhere 16 -> Create event -> new option FOR ALL |

Dev	ivangron
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	App - New Features
Version	16.0

Add new options for Events Objects

1 attachment

Screen Shot 2014-11-27 at 10.44.26 AM.png

2014-11-27T18:44:45Z

70 KB

All Comments (5) Change History

ivangron 2014-11-11T22:58:58Z

Discovered that extraction and scripting of events was incomplete. Modified extraction and scripting to include all its correct options and include its schedule options. Changes will affect versions 10 and greater. New For All option is only for version 16 and greater.

ivangron 2014-11-11T23:01:29Z

examples:

CREATE EVENT DailyBackup

SCHEDULE daily_backup START TIME '1:00AM' EVERY 24 HOURS

HANDLER

BEGIN

BACKUP DATABASE TO '\\\\.\\tape0'

ATTENDED OFF

END;

CREATE EVENT IncrementalBackup

SCHEDULE START TIME '1:00 AM' EVERY 24 HOURS

HANDLER

BEGIN

BACKUP DATABASE DIRECTORY 'c:\\backup'

TRANSACTION LOG ONLY

TRANSACTION LOG RENAME MATCH

END;

CREATE EVENT HourlyLogBackup

SCHEDULE hourly_log_backup BETWEEN '8:00AM' AND '6:00PM' EVERY 1 HOURS ON ('Monday','Tuesday','Wednesday','Thursday','Friday')

HANDLER

BEGIN

BACKUP DATABASE DIRECTORY 'c:\\database\\backup'

TRANSACTION LOG ONLY

TRANSACTION LOG RENAME

END;

CREATE EVENT evt1 FOR ALL

HANDLER

BEGIN MESSAGE CURRENT TIME || ' evt1 active' TO CONSOLE; END

CREATE EVENT DailyBackup

SCHEDULE schedule_name_01 START TIME '10:00:00 AM' START DATE '12/21/2014',

SCHEDULE schedule_name_02 START TIME '11:00:00 PM' START DATE '12/22/2014',

SCHEDULE schedule_name_03 START TIME '12:00:00 PM' START DATE '12/23/2014'

HANDLER BEGIN BACKUP DATABASE TO '\\\\.\\tape0' ATTENDED OFF END;

CREATE EVENT DailyBackup1

SCHEDULE schedule_name_01 START TIME '1:00:00 AM' EVERY 12 HOURS ON (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31) START DATE '12/21/2014'

HANDLER BEGIN BACKUP DATABASE TO '\\\\.\\tape0' ATTENDED OFF END;

CREATE EVENT DailyBackup2

SCHEDULE schedule_name_03 BETWEEN '1:00:00 AM' AND '5:00:00 AM' EVERY 75 MINUTES ON ('MONDAY', 'TUESDAY', 'WEDNESDAY', 'THURSDAY', 'FRIDAY', 'SATURDAY', 'SUNDAY') START DATE '12/11/2014'

HANDLER BEGIN BACKUP DATABASE TO '\\\\.\\tape0' ATTENDED OFF END;

CREATE EVENT DailyBackup3

SCHEDULE schedule_name_01 START TIME '1:00:00 AM' EVERY 12 HOURS ON (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,0) START DATE '12/21/2014'

HANDLER BEGIN BACKUP DATABASE TO '\\\\.\\tape0' ATTENDED OFF END;

examples:

CREATE EVENT DailyBackup

SCHEDULE daily_backup START TIME '1:00AM' EVERY 24 HOURS

HANDLER

BEGIN

BACKUP DATABASE TO '\\\\.\\tape0'

ATTENDED OFF

END;

CREATE EVENT IncrementalBackup

SCHEDULE START TIME '1:00 AM' EVERY 24 HOURS

HANDLER

BEGIN

BACKUP DATABASE DIRECTORY 'c:\\backup'

TRANSACTION LOG ONLY

TRANSACTION LOG RENAME MATCH

END;

CREATE EVENT HourlyLogBackup

SCHEDULE hourly_log_backup BETWEEN '8:00AM' AND '6:00PM' EVERY 1 HOURS ON ('Monday','Tuesday','Wednesday','Thursday','Friday')

HANDLER

BEGIN

BACKUP DATABASE DIRECTORY 'c:\\database\\backup'

TRANSACTION LOG ONLY

TRANSACTION LOG RENAME

END;

CREATE EVENT evt1 FOR ALL

HANDLER

BEGIN MESSAGE CURRENT TIME || ' evt1 active' TO CONSOLE; END

CREATE EVENT DailyBackup

SCHEDULE schedule_name_01 START TIME '10:00:00 AM' START DATE '12/21/2014',

SCHEDULE schedule_name_02 START TIME '11:00:00 PM' START DATE '12/22/2014',

SCHEDULE schedule_name_03 START TIME '12:00:00 PM' START DATE '12/23/2014'

HANDLER BEGIN BACKUP DATABASE TO '\\\\.\\tape0' ATTENDED OFF END;

CREATE EVENT DailyBackup1

SCHEDULE schedule_name_01 START TIME '1:00:00 AM' EVERY 12 HOURS ON (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31) START DATE '12/21/2014'

HANDLER BEGIN BACKUP DATABASE TO '\\\\.\\tape0' ATTENDED OFF END;

CREATE EVENT DailyBackup2

SCHEDULE schedule_name_03 BETWEEN '1:00:00 AM' AND '5:00:00 AM' EVERY 75 MINUTES ON ('MONDAY', 'TUESDAY', 'WEDNESDAY', 'THURSDAY', 'FRIDAY', 'SATURDAY', 'SUNDAY') START DATE '12/11/2014'

HANDLER BEGIN BACKUP DATABASE TO '\\\\.\\tape0' ATTENDED OFF END;

CREATE EVENT DailyBackup3

SCHEDULE schedule_name_01 START TIME '1:00:00 AM' EVERY 12 HOURS ON (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,0) START DATE '12/21/2014'

HANDLER BEGIN BACKUP DATABASE TO '\\\\.\\tape0' ATTENDED OFF END;

narendravatsaraj(*) 2014-11-24T07:56:16Z

Please update resolved build number.

dutondeumesh 2014-11-25T04:56:19Z

Can you confirm the fix build? we still don't have option to create event after right click on "Events" under schema node.

tariqrahiman 2014-11-27T18:55:51Z

Verified the Script Object -> Create and Drop of Sybase Anywhere events. Fixed in 16.0.0-dev-52

Search Tips

Aqua Data Studio / nhilam

Sybase Anywhere 16 -> Create event -> new option FOR ALL |

1 attachment

Issue #12707

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Sybase Anywhere 16 -> Create event -> new option FOR ALL |

1 attachment

Issue #12707

Completion