ReportWORQ Distribution Jobs can be scheduled for repeated execution. This article explains how to schedule Job execution from within ReportWORQ. Alternatively, you can configure an external scheduler to run Jobs using the ReportWORQ API.
Scheduled Jobs run only if the Scheduler Service is enabled at the scheduled run time. The Enable Scheduler Service setting is available in the Execution area of the Administration > Configuration interface, as shown below:
A schedule can run a single Job or multiple Jobs, and you can create as many schedules as needed. You can also create a whitelist of dates that completely overrides the configured run dates, or a blacklist of dates to make ReportWORQ skip execution of scheduled Jobs on certain days. You can disable these date filters (whitelist and blacklist) to revert to the configured run dates.
The Scheduler provides a basic user interface for setting a recurring schedule. ReportWORQ also supports an advanced mode, based on Cron syntax, which allows for more customized schedules. Visit Crontab Guru for more details about Cron and examples of Cron syntax. For more information about advanced scheduling options, visit the ReportWORQ Forum.
If a Job contains parameter values, you can configure the schedule to override those values with ones you provide. For example, if a Job is configured to run for a specific Business Unit, you could configure one schedule to run and send reports for Business Unit A daily, and another to run and send reports for Business Unit B reports weekly.
To schedule Jobs within ReportWORQ:
On the ReportWORQ sidebar, select the Schedules icon.
A list of schedules appears.
Select the + Add Schedule button.
The schedule editor appears..png)
In the Options area, provide a Name for the schedule.
Do one of the following to specify how often the scheduled Jobs run:
Select settings from the Frequency dropdown lists.
Select the edit icon
to switch to the advanced scheduler, which uses crontab schedule expressions.
For more information about advanced scheduling options, visit the ReportWORQ Forum.
If you want to override the schedule to exclude specific dates (blacklist) or to run only on a specific set of dates (whitelist), create a Date Filter:
Select the link beside Date Filter.
The Edit Date Filters pane appears:
Select a Filter Mode:
Blacklist — Jobs in this schedule will not run on the dates specified in the filter. They will run on all other scheduled dates.
Whitelist — Jobs in this schedule will run only on the dates specified in the filter. Dates specified in the Frequency dropdown lists or in a crontab schedule expression are ignored.
Do one of the following to specify filter dates:
To manually specify dates for the filter, set Filter Source to Manual and then type the dates in the Filter Dates box.
Each date or date range must appear on a separate line. The format for a single date is yyyy/MM/dd. The format for a date range is yyyy/MM/dd-yyyy/MM/dd.If you want ReportWORQ to retrieve the filter dates from a text file (.txt), set Filter Source to File, and then specify the file path including filename.
The advantage of using a text file is that you can edit the file outside of ReportWORQ anytime to modify the filter dates. Changes made in the text file may take up to one hour to apply in ReportWORQ.
The text file must contain one or more dates and/or date ranges. Each date or range of dates must appear on a separate line. The format for a single date is yyyy/MM/dd. The format for a date range is yyyy/MM/dd-yyyy/MM/dd.
Optionally, you can provide a Notification email address for receiving status notifications about the schedule:
Notifications are available only if the Email Distributor has been configured.
By default, a notification is sent when the scheduled jobs are complete or when a job fails. If you prefer to be notified only if a job fails, also select Send Notification on Failure Only.
If you want to test whether the schedule will run successfully but you don’t want to distribute Job output yet, select Hold for Delivery and clear Send Notifications on Failure Only.
For more information, see the test procedure immediately below this set of steps.
In the Selection area, select one or more Jobs to run on this schedule.
Tip: If you select a folder, all Jobs in the folder are selected.
Optionally, you can override the values of parameters that are used in the scheduled Job(s):
In the Parameter Overrides area, select the pencil icon beside the parameter you want to override.
The Edit Parameter pane appears. The example below shows values for a parameter named Region.
Specify the Parameter Type and the data or source of data for the parameter values.
For more information, see Configuring Parameters.Select Save & Close.
At the top of the options area, select Enabled.
Select Save Changes.
To Test a Schedule:
In the list of schedules, select the schedule you want to test.
The schedule editor appears.In the Options area, select Hold for Delivery and clear Send Notifications on Failure Only.
Select Save Changes.
In the list of schedules, select the play button beside the schedule you are testing.
The schedule runs immediately. After the Jobs are finished, ReportWORQ sends a notification email that lists the scheduled Jobs and indicates the success or failure status of each.Review the email notification to confirm desired behavior.
When you are ready to let the schedule run unimpeded, clear Hold for Delivery, select Send Notifications on Failure Only if desired, and Save Changes.