Treasure Data supports these flexible scheduling options:
- daily
- weekly
- monthly
- start date
- end date
Set a Daily Schedule
If a daily workflow schedule does not progress as expected, it might be due to one of two things:
- You didn't set a timezone, and therefore the default timezone of UTC is changing the daily schedule.
An existing daily session has already started, and therefore, your daily schedule will run the next day. Learn more at TD Workflow FAQs.
In the following example, the workflow runs every day.
1. Open TD Console
2. Navigate to Data Workbench > Workflows.
3. Open an existing workflow or create a new one.
4. Select Launch Project Editor.
_export: td: database: workflow_time timezone: America/Chicago schedule : daily>: 07:00:00
Set a Weekly Schedule
In the following example, the workflow runs every Sunday at 09:00.
1. Open TD Console
2. Navigate to Data Workbench > Workflows.
3. Open an existing workflow or create a new one.
4. Select Launch Project Editor.
_export: td: database: workflow_time timezone: America/Chicago schedule : weekly>: Sun, 09:00:00
Set a Monthly Schedule
In the following example, the workflow runs on the 1st day of every month at 10:00.
1. Open TD Console
2. Navigate to Data Workbench > Workflows.
3. Open an existing workflow or create a new one.
4. Select Launch Project Editor.
_export: td: database: workflow_time timezone: America/Chicago schedule : Monthly>: 1, 10:00:00
Set a Start Date
In the following example, the workflow run starts on 2022-10-05 and runs daily at 7:00 a.m.
1. Open TD Console
2. Navigate to Data Workbench > Workflows.
3. Open an existing workflow or create a new one.
4. Select Launch Project Editor.
_export: td: database: workflow_time timezone: America/Chicago schedule : start>: 2022-10-05 daily>: 07:00:00
Set a Start Date with Start Time
In the following example, the workflow run starts on 2022-10-05 and runs daily at 7:00 a.m.
1. Open TD Console
2. Navigate to Data Workbench > Workflows.
3. Open an existing workflow or create a new one.
4. Select Launch Project Editor.
_export: td: database: workflow_time timezone: America/Chicago schedule : start>: 2022-10-05 daily>: 07:00:00
Set a Start and End Date
Setting an end date can help you end campaign workflows on a set schedule, so there is no accidental running of a workflow after completing a campaign.
How End Dates Work
- The workflow scheduler stops scheduling the workflow past YYYY-MM-DD.
- The time for the end schedule always defaults to "end date HH:MM:SS"; the user-defined date and not exceeding "end date 23:59:59".
Example
In the following example, the schedule runs the workflow daily from 7:00 a.m until 2022-10-04.
1. Open TD Console
2. Navigate to Data Workbench > Workflows.
3. Open an existing workflow or create a new one.
4. Select Launch Project Editor.
_export: td: database: workflow_time timezone: America/Chicago schedule: daily>: 07:00:00 end>:2022-10-05