Schedule a Database
Early Adoption Program—EAP
After creating a database, you may schedule when it starts, stops, or scales to economize on AU costs (see Database Cost and Actian Units).
You may create one or multiple schedule events to stop, start, or scale a database using these elements:
Action | Recurrence | Time Increment |
|---|---|---|
• Start Database • Stop Database | • Interval – event duration, from 0 hours, 15 minutes to 23 hours, 45 minutes • Schedule Once – date and time to run an event • Daily – every day of the week • Every weekday (Mon–Fri) • Weekly – particular weekdays • Monthly – month 1–12 on a particular day of the month • Custom (quartz cron expression—see Cron Expressions) | Fifteen-minute increments, 12:00 AM – 11:45 PM |
To create or delete a schedule event, follow the appropriate procedure:
•
To create a start/stop schedule event
1. In the Actian Database Instances console, click the database name to display its Database Instance Details page.
2. In the Schedule row, click the Create Schedule icon:
The Schedule Database Action dialog opens.
3. Select an Action for the event:
• Start Database
• Stop Database
4. Choose a Recurrence interval:
• Interval
• Schedule Once
• Daily
• Every weekday (Mon–Fri)
• Weekly
• Monthly
• Custom
5. Select a Start time for the action:
Recurrence | Setting |
|---|---|
• Interval – event duration | Select an interval from 0 hours, 15 minutes to 23 hours, 45 minutes |
• Schedule Once – trigger a one-time event | Select a day of the month and an execution time from 12:00 AM – 11:45 PM. |
• Daily – every day of the week • Every weekday (Mon–Fri) | Select a start time from 12:00 AM – 11:45 PM. |
• Weekly – particular weekdays | 1. Select one or more weekdays for the action. 2. Select a start time from 12:00 AM – 11:45 PM. |
• Monthly – month 1–12 on a particular day of the month | 1. Select a month for the action. 2. Select a month day for the action. 3. Select a start time from 12:00 AM – 11:45 PM. |
• Custom | Enter a custom cron expression in the field. See Cron Expressions. |
6. Click the Schedule button to create the action.
The schedule action is added to the list at the bottom of the dialogue.
7. Click the Add Schedule button to add another schedule event and repeat steps 3–6.
To delete a schedule event
1. In the Database Instances console, click the database name to display its Database Instance Details page.
2. In the Schedule row, click the Create Schedule icon:
The Schedule Database Action dialog opens.
3. Scroll down to the list of schedule events.
4. To search for a particular event by action or recurrence, enter text in the search field: 
5. When the schedule event is shown in the list, click the delete icon on its right:
6. Confirm the deletion.
The schedule event is removed from the events list.
Last modified date: 12/12/2024