The Scheduled Tasks function in the Tools menu and the Tools tab of the ribbon allows you to manage the tasks for the reports you've scheduled.

This function is not available if you are running Stonefield Query on Citrix or if you do not have an Ultimate license.

Choose which folder you want tasks displayed from. Use root folder means the "root" folder in the Windows Task Scheduler. Use "Stonefield Query" folder means use that folder.

The list at the left shows the tasks in the selected folder that you've scheduled to run reports. The list normally displays tasks alphabetically but you can turn on the Sort by next run setting to display them in order of when they're scheduled to run next.

Select one of the tasks in the list to display information about the task, including status (normally "Ready" but may display "Running" if the task is currently running), when it's scheduled to run next, when it was last run, and the results of the last run (both a code and a description of the result).

To edit a task, click the Edit button. This opens the Schedule Report Wizard for that task, allowing you to change its settings. To delete a task, click the Delete button. To disable a task without deleting it, such as when you are about to install a new version and don't want tasks to run, which would interfere with the installation, turn off the Enabled setting. Turn it back on again to re-enable the task.

You can delete or disable/re-enable several tasks at the same time by selecting the desired ones in the list (select the first one, then hold down the Ctrl key as you select the other ones) and then chosing the desired operation.

You can manually run a task by clicking the Run button. The task runs immediately and the display refreshes automatically every five seconds to display the current status of the task. You can also manually click the Refresh button to display the status. To stop a running task, click the Stop button.

Turn on the Create diagnostics for each schedule run setting if you are having problems with a task not running or it does run but the output isn't being created or emailed. With this setting turned on, Stonefield Query creates a separate diagnostics file in the Data subdirectory of the Stonefield Query program folder, named Diagnostics.TaskName.Timestamp.txt, where TaskName is the name of the task and Timestamp is the date and time the task was run, formatted as YYYYMMDDHHMMSS, such as "20150206141500" for a task run at 2:15 p.m. on February 6, 2015. You can send this diagnostics file to technical support so they can analyze the problem.

The Diagnostic button displays the content of the most recent diagnostic file for the selected task.

The Import button allows you to import a scheduled report. This is commonly used when moving Stonefield Query to another computer and you want to move the scheduled tasks for the reports as well. To do so, copy the xml files in the Schedules subdirectory of the folder where reports were stored on the old computer to some location on the new computer, click Import, and select one or more of the xml files. For each one, the Schedule Wizard opens so you can edit any settings necessary.

This only works with xml files created in version 8.4 or later. To make sure the xml files have the correct format, edit each scheduled task (select it in the Scheduled Tasks dialog and click Edit) on the old computer, click Next until you reach the final step, and click Finish. This will update the xml file with the information needed for importing. Then copy the updated xml files to the new computer and import them.