Scheduling a query run

QUERY > Scheduling a query run

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

Under Run options, click Run later, and then click 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

Do one of the following:
- Click Capture SAP details to automatically retrieve the information that is selected on the SAP Logon dialog box. Clicking Capture is the easiest and most error-free method for adding logon details to the scheduler.
-or-
- Type in the required information in the fields.

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.
Partner	Specify this connection parameter if you select single sign on.
Client	Enter the client number.
User name	Specify the user name.
Password	Specify the SAP password for the user.
Language	Specify the language that the system should use.
EP URL	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.

Click Test to confirm that your logon information works. Click Next.

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.
Password	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