Create a Schedule

Before creating a schedule, it is important to understand how the schedule dates and the template date filters relate to each other. See Understanding Date Settings for more information.

To create a schedule

1. Click Templates and select either the Default or Personal tab.
2. Select the desired template.
3. Click Schedule. The Save Schedule dialog displays with a Properties tab and an Email tab.

   

4. In the Properties tab complete all fields as described below.
   • Name - (Required) Modifiable field pre-populated with the name of the saved template. Creates the name of the schedule and the name of the report generated by the schedule. Max character limit is 256. Accepts alphanumeric characters only. Does not support the use of any special characters.
   • Description - Modifiable field pre-populated with the description from the saved template. Field can be blank. Max character limit is 512.
   • Format - Determines the format of the saved report generated by the schedule. Choices include: Excel, HTML, CSV (default), PDF. When opened, a saved report displays in the viewer associated with the file type on the user's machine.

     Note: Reports saved in the Excel format may have an extra column in every row. You cannot hide this column in the report template, however you can remove the column once you open the report in Excel.

   • Delete In - Determines when the report generated by the schedule will be automatically deleted from the Results tab. Choices include: 7 Days (default), or 30 Days. To store a report for longer than 30 days, use the Download option.
   • Include report parameters - When checked, parameters such as template name, description, date generated, input options, and last successful database refresh will display in the report generated by the schedule. Default is unchecked. Cannot include parameters in a CSV file.
5. In the Schedule section, select the type of schedule you want to create from the drop down. Complete all fields as described below.

   Note: The time zone for all schedule Start times is UTC.

   One Time Schedule

   Create a one time schedule if you only need a snapshot of the data for one period in time.

   

   Complete all fields as described below.

   • Start - (Required) Determines the date the schedule should become active. The schedule will run the report once and not reoccur. Default is current day's date.
   • Start Time - (Required) Determines the time of day the report will be queued for execution. Default is 3:00 AM UTC time.

   Daily Schedule

   Create a daily schedule if you need the report to run on more than one day a week.

   

   Complete all fields as described below.

   • Start - (Required) Determines the date the schedule should become active. Default is current day's date.
   • End by - Determines the date the schedule becomes inactive and reports stop running. If left blank, the report will reoccur indefinitely.
   • On the following days - Determines which days of the week the report will run. Select one or more days.
   • Start Time - (Required) Determines what time of day the report will be queued for execution. Default is 3:00 AM UTC time.

   Weekly Schedule

   Create a weekly schedule to run the report on only one day of the week.

   

   Complete all fields as described below.

   • Start - (Required) Determines the date the schedule should become active. Default is current day's date.
   • End by - Determines the date the schedule becomes inactive and reports stop running. If left blank, the report will reoccur indefinitely.
   • On the following day - Determines which day of the week the report will run. Select only one day.
   • Start Time - (Required) Determines what time of day the report will be queued for execution. Default is 3:00 AM UTC time.

   Monthly Schedule

   Create a monthly schedule to run the report on the same day of each month.

   

   Complete all fields as described below.

   • Start - (Required) Determines both the date the schedule becomes active and the day of the month the report will run. If the date is 29, 30, or 31 the report will not run for months that do not contain that date.
   • End by - Determines the date the schedule becomes inactive and reports stop running. If left blank, the report will reoccur indefinitely.
   • Start Time - (Required) Determines what time of day the report will be queued for execution. Default is 3:00 AM UTC time.

6. If desired, click the Email tab and check or uncheck the option.
   • Email Notification - Sends an email to the user's SkillPort email address that indicates the scheduled report ran. If no email address is specified for the SkillPort user account, this check box will be disabled. If the current user account email address is changed, any existing schedules will not be automatically updated.
7. Click OK. The schedule displays on the Schedules window.