Scheduling a query run

QUERY > Scheduling a query run

Back to

Scheduling a query run

With QUERY, you can schedule unattended query runs, including runs of linked queries.

Queries can be scheduled only after the script is approved after submitting to Central. For more information, see "Sending a file for approval".

Winshuttle Query offers two ways to schedule, which are dependent on the type of destination for the query output:

Run Later: For Excel, XML, text, Access. Uses your SAP autologon files to run a local script and data template and to return output data to the local computer.
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.
Run Later (SERVER): SQL Server, Excel, and SharePoint lists. Uses SAP credentials that are saved on Central to run query scripts and write data to a non-local destination. Note that for Excel files, Run later (SERVER) appears only after the file has been approved and the file is in Production status.
Note: System post is currently not available for Winshuttle Query.

Run Later

To schedule to run later

On the Run pane, under Run options, click Run later, and then click the Run button.
The Schedule Run wizard appears. Follow the steps to schedule a query run.

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 on to Windows.
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.

Run Later (SERVER)

In a Winshuttle Central deployment, you can schedule a query to run on Central and send extracted data to Excel files, SharePoint lists, or to a SQL server database by using the SAP system account that is assigned in CENTRAL. To use Run Later (SERVER), Winshuttle SERVER must be a part of your deployment and you must have the correct permissions in Central to run files. If SERVER is not available in your deployment, the Run Later (SERVER) option is not available. Note that Excel files must have first been submitted to Central for approval before they can be scheduled to run.

On selecting the Run Later (SERVER) option and clicking Run (from Excel add-in or QUERY client), the following Web-based screen from CENTRAL appears.

On the second page of the wizard, you can select the SAP system on which you want to run the file. The SAP system lists show only the application servers for which the current user has SAP credentials stored on the CENTRAL site.

The delegated SAP credentials are used to run the file. These credentials are specified during mapping for SQL server and SharePoint lists.
If there are no SAP systems available, none of the functions are available, except for the Cancel button. You are prompted to add your SAP credentials to the system.

In page 3 of the wizard, specify when you want the query to run.

• Policy checks are performed on your credentials for the time when this file is scheduled. If you are restricted by a policy from running this file at the scheduled date and time, you are notified.

• Policy checks are performed again at the time of execution on SERVER.

Using the Scheduler

Jobs must be edited from CENTRAL. The Manage Scheduled Jobs from CENTRAL button the Scheduled job list in CENTRAL from within QUERY.

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