Schedule a Query run - Automate_Studio - 20.3

Automate Studio with Connect User Guide

Product type
Software
Portfolio
Integrate
Product family
Automate
Product
Automate > Automate Studio
Version
20.3
Language
English
Product name
Automate Studio
Title
Automate Studio with Connect User Guide
First publish date
2018
Last updated
2024-10-22
Published on
2024-10-22T07:54:52.852256

When you use the Scheduler to schedule a run in advance, Query automatically connects to SAP, runs the Query on the schedule you set up, and then closes the connection with SAP. Studio can send an email notification confirming that the scheduled job was performed.

Note:

For information about running Automate with Citrix, see Citrix installation with Automate products.

Use Studio to schedule a script

  1. On the Run tab, click Schedule.

    If you are not logged on, the SAP Logon box will open so that you can log on to the SAP system.

  2. Confirm the criteria that are displayed in the Run Time Variable Wizard by clicking OK.
  3. In the Automate Scheduler box, in the Title box, type the title you want Studio to show in the list of scheduled tasks.
  4. In you want to receive scheduling notifications, type your email address in the Send email notifications to box. Use commas to separate multiple email addresses.
    Note:

    If you are using an Exchange server to send email notifications, you can include the results file with the email message by checking the Attach data file box. To set this up, provide the Exchange server details in the Studio Options.

  5. In the Run reason box, you can change the reason for the run.
  6. Click Next.
  7. Click One time, Daily, Weekly, or Monthly.
  8. Choose the recurrence options you want. These options change depending on what you clicked in step 7.Under Advanced Settings, you can choose to run the script multiple times. For example, if you want to run the script monthly on the fifth day, and you want to run the script at the beginning and the end of the day, check the Task recurs every box, click 12 Hours, and click 1 Day.
  9. If the script will run multiple times, choose a setting in the System-generated file name list to avoid overwriting the data in the data file every time the script runs. Based on the setting that you choose, Studio will add the date, the date and time, or the user name of the logged-on user to the file name. This option is available only for Excel data files. You can choose to append a time stamp to the Query result file name.
  10. Click Finish.

Change the schedule or stop scheduling a run

  1. Click the File tab.
  2. Click Scheduled Tasks, and then click the task that you want to stop or change.
  3. Click Delete, or click Edit to make changes in the Automate Scheduler box.

Limitation

If template contains cell comments, drawing objects, pivot table, and form controls (such as buttons, check-boxes, list boxes) then these control will not be preserved from Excel files.