Back to


Scheduling a query run

With QUERY, you can schedule unattended queries. You can schedule queries that return data to Excel, XML, or text files and to Access tables. Scheduling uses your SAP autologon files.

To schedule a run

The Schedule Run wizard appears. Follow the steps to schedule a query run.

Note: To run a scheduled script on a virtual machine (VM) with Windows 7 or later or Windows Server 2008 or later, you must remain logged on to the VM.
For information about running Winshuttle with Citrix, see Citrix installation with Winshuttle products.

To complete the Schedule Run Wizard

SAP System Name

Specify the SAP system name

Application Server Host

Enter the host name.

System number

Specify the system number.

Use Logon Group

Select this check box to update logon group information.

Logon Group

If available, type the auto logon group information.

Message Server Host

If available, type the message server host information.

Use SSO1

Select this check box to enable single sign on. With single sign on, the SAP system uses the Windows credentials (user name and password) for each user.


Specify this connection parameter if you select single sign on.


Enter the client number.

User name

Specify the user name.


Specify the SAP password for the user.


Specify the language that the system should use.


If available, specify the enterprise portal URL.

E-mail notification

Type the e-mail address for the person who you want to receive notification by e-mail message when the scheduled run is completed. You can specify multiple e-mail addresses that are separated by semicolon.

Attach data file to the mail

Select to attach the results file to the e-mail message.

Run on console

Run on console is selected by default. This setting cannot be modified.

  1. Click Test to confirm that your logon information works. Click Next.
  2. On page 3, select the following options:

    Perform this task:

    Once: Schedules a one-time run. If you select Once, you can set the Run on date.

    Daily: Schedules a daily run.

    Weekly: Schedules a weekly run. If you select Schedule Weekly, enter the weekly frequency. You can also specify the day of the week for the run. (The Weekly setting is not available for SQL Server.)

    Monthly: Schedules a monthly run. If you select Schedule Monthly, enter either the date each month for the run or the ordinal date. You also mark the months for the run.

    Run as

    If you want the task to run even if you are not logged on, enter your Windows user name.

    Start Time

    Select the time of day when the scheduled task is to take place.


    Enter the password the user provides to log onto Windows.

    System Generated File Name

    Generates a unique filename for the output file that can include the name of the SAP user, or the date of the run, or the date and time of the run.

    Adding this information to filenames can be useful if the file is used in automated processes.

    Run only if logged on

    When selected, the user must be logged on for the scheduled task to be completed. This setting is not applicable for Windows 7.

The Scheduler pane

In the Scheduler pane you can manage all your scheduled queries. View the query name, the name of the output (data) file, the time when the run is scheduled, the last date and time when the query was run, the next time the query is scheduled to run, and the e-mail address of the person who will receive notification that the query has run. You can also set the schedule for queries.

To open the Scheduled jobs pane

On the Tools tab , click the Scheduler button .

Calendar view

When the scheduled job pane opens, a calendar view is displayed, with each scheduled job as a calendar item. Each item shows a 30-minute duration, regardless of how long the actual job might take.

Note: If you are using the App Model version of Central, you cannot reschedule a task in the Calendar view. Instead, you must delete the scheduled task and create a new scheduled task.

To edit a schedule

Basic view

You can view scheduled jobs in a grid that contains columns for each descriptor.

To view items in Basic View

Also in this section

Introducing QUERY

New Features in Winshuttle QUERY version 10.6/10.7

Getting help in Winshuttle QUERY

Setting preferences



Running the query

Managing QUERY

Advanced features

Windows error messages