Stonefield Query has a scheduler that allows you to run certain reports at certain times. For example, you may have a report named Daily Activities that you want emailed to someone every morning at 7:00 am. The Stonefield Query scheduler uses the scheduler built into Windows to perform the actual report run but makes it easier to schedule a report than the Windows Scheduler program.Here's how to schedule a report:
- Select the desired report.
- Choose Schedule Report from the Tools menu.
- In Step 1, specify the name to assign to the task (this name is used as the name for the Windows Scheduler task), how often the report is run (daily, weekly, or monthly), and the time the report is run.
- Click the Next button. Which options appear in the next step depends on whether you choose a daily, weekly, or monthly schedule.
- For a daily schedule, specify whether the report runs every day, on weekdays only (Monday through Friday, inclusive), or every few days (specify how many days apart the report runs, such as every 3 days). Enter the date for the first run of the report.
- For a weekly schedule, specify how many weeks apart the report runs (such as every 3 weeks) and on which days to run the report.
- For a monthly schedule, specify whether the report runs on the same date of every month (for example, the 15th) or the same day (such as the second Monday). Specify which months the report runs in (the default is every month).
- Click the Next button and specify where the output is sent. The default is to print report, but you can also choose to output the report to a file or email. The options in this step are the same as they are in the Output page of the Reports Explorer.
- If the report is emailed to someone, click the Email To button and specify the email recipient(s), the subject, and the body of the message; see the Output Options topic for more information on the Email Properties dialog. The report is output as a PDF file and emailed to the specified recipient(s).
- A scheduled report has to run under a specific Windows account, so click the Next button and enter the login name and password of the account to run the report under. Normally, this is your usual Windows user name and password. Note that the scheduled task cannot be saved if you don't have a password for your Windows account.
- When you are finished specifying the settings for the schedule, click the Finish button. The report runs automatically on a regular basis according to the schedule settings.
To edit a schedule for a report, follow the same steps as above. Stonefield Query sees that you're scheduling a report that's already been scheduled and displays the settings for the existing schedule. Change any settings you wish and choose Finish (notice that you must enter the account information each time).
If you want to create a new schedule for the report, specify a different schedule name. The existing schedule for the report is left alone and a second schedule is created for the report when you choose Finish.
Note that the Schedule Wizard adds the name of the database to the schedule so the report is run against the database open when the schedule was created rather than the last database accessed.
To see whether a schedule report ran correctly, click the Windows Start button and choose All Programs, Accessories, System Tools, Scheduled Tasks (Task Scheduler in Windows Vista). In the dialog that appears, select the desired schedule and check the Last Result (Last Run Result in Windows Vista) column: it shows the result of the run and if it failed, displays the same code values discussed in the Running from Other Applications topic.
To delete a schedule for a report, click the Windows Start button and choose All Programs, Accessories, System Tools, Scheduled Tasks. In the Scheduled Tasks dialog, select the desired schedule and press the Delete key.