Back to

Running scripts

Scheduling runs

The built-in Scheduler allows you to run your TRANSACTION files in an unattended mode at a user-defined pre-scheduled time. Any script can be set up to run automatically on a schedule by using the Run Later (Scheduling a Run) option on the Run screen. You can also set up a new run using Scheduler, as described below.

When you select Schedule a run, the Windows Open dialog box is displayed. Select and open the script you want to schedule. Then use the Schedule Upload Wizard to enter the settings for the run.

When you schedule an automated run, TRANSACTION performs the following process:

You can also use the Scheduler to edit any of the settings for the scheduled jobs listed or to delete a job run as needed.

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.

Selecting the Scheduler

To open the Scheduled jobs pane

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.

To edit a schedule

  1. Hover over an item to see the details of a job.
  2. Double-click the item. The Scheduling wizard opens. Complete your edits.
  3. For date and time changes, drag the item to the new date or hour.
  4. Click Week, Month, or Day to display the calendar duration that you want.
  5. To change the year, or the month or day, click the arrows at the upper right.

Basic view

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

To view items in Basic View

  1. Click Basic View.
  2. To change details of a job, click Edit.
  3. To remove a query from the schedule queue, click Delete .
  4. To view the status of a job, click Check StatusCheckStatus. If a job has run more than once, the date and time are listed on the left. Click a date to view the status of that run. The file box CheckStatusFile also contains the names of all files associated with a job.
  5. To schedule a run from the Scheduler pane, click Schedule a run .

Run on console

If the query is to be run from the command line, select Run on console.

You can edit any of the jobs in the scheduled run using these settings:

When you select Edit, the Windows Open dialog box is displayed. Select and open the TRANSACTION script schedule you want to edit. Then use the Schedule Upload Wizard to enter the settings for the run.

Running a Recording (Access Data Source)

The Run screen allows you to enter the run-time settings you want to use and then click  (Run button) to execute the recording as shown below. You can also click Validate to confirm that data in a file does not have errors, without uploading the data to the server. You do not have to create a separate validation file.

Validation is recommended when a TRANSACTION script is passed to a Runner user. The Runner user first validates the data, and then runs the file to upload the data.

Before you run a mass update and start modifying a large number of records, we recommend that you first do a test run with one or two records. Once you are satisfied with the test run, you may proceed with your mass update.

NOTE: TRANSACTION supports recording of only one transaction for each TRANSACTION script. If you want to use multiple transactions, you can record multiple scripts and link them together.

When the Scheduler is used, TRANSACTION automatically connects to SAP, runs the transaction on a predefined schedule you create, and closes the connection with SAP upon completion. You can send an e-mail notification indicating that the scheduled job was performed.

To schedule a run

To open the Scheduled jobs pane

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.

To edit a schedule

  1. Hover over an item to see the details of a job.
  2. Double-click the item. The Scheduling wizard opens. Complete your edits.
  3. For date and time changes, drag the item to the new date or hour.
  4. Click Week, Month, or Day to display the calendar duration that you want.
  5. To change the year, or the month or day, click the arrows at the upper right.

Basic view

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

To view items in Basic View

  1. Click Basic View.
  2. To change details of a job, click Edit.
  3. To remove a query from the schedule queue, click Delete .
  4. To view the status of a job, click Check StatusCheckStatus. If a job has run more than once, the date and time are listed on the left. Click a date to view the status of that run. The file box CheckStatusFile also contains the names of all files associated with a job.
  5. To schedule a run from the Scheduler pane, click Schedule a run .

Also in this section

Running multiple or linked files

Run options, troubleshooting errors, and Launch GUI

Advanced run settings

Writing headers

Publishing macros in an Excel workbook

Uploading long text

Uploading characters in Japanese to SAP

Windows scripting