Schedule a Transaction 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
Topic type
Overview
Administration
Installation
How Do I
First publish date
2018

When you use the Scheduler to schedule a run in advance, Studio automatically connects to SAP, runs the transaction 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

Schedule Local: Schedule to run from your computer

  1. Click the File tab from Studio, click Transaction Solution Library, and open the solution that you want.
  2. On the Run tab, click the Schedule arrow and click Schedule Local.
  3. In the Automate Scheduler box,:
    1. Choose SAP server for schedule.
    2. In the Title box, type the title you want Studio to show in the list of scheduled tasks.
    3. In the Send Email Notifications To box, type the email address where you want to receive scheduling notifications.
      1. Use commas to separate multiple email addresses.
    4. If you are using an Exchange server to send email notifications and using an Excel or Access data file, 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 Reason box, you can change the reason for the run.
    6. Click Next.
  4. Click One Time, Daily, Weekly, or Monthly.
  5. Choose the recurrence options you want.

    1. 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 Repeat task every box, click 12 Hours, and click 1 Day.
  6. To stop running the scheduled script, check the Expires on box and then enter a date and time.
  7. Click Finish.

Schedule Server: Schedule on Server with No Data Review process

  1. If the approved script and data file are not already open, click the File tab, click Transaction Solution Library, and open the script that you want.
  2. On the Run tab, enter the data to upload.
  3. Click the arrow under Schedule and click Schedule Server.
  4. Save the data file to your computer.
  5. In “Save to library” pop up, edit file name (optional) and click Ok.
  6. Select the SAP system.
  7. In the Automate Scheduler box, enter the start date and the start time.
  8. Click Finish.
Note:

Server based posting and scheduling is supported in Studio Manager for Standard workflows for Excel files.

Use the Excel Add-in to schedule a run

Schedule Local: Schedule to run from your computer

  1. Launch Excel and open a new blank workbook.
  2. Click the Studio tab and log on to Studio.
  3. Click the Evolve tab, click Open, go to My Template, click Open Transaction Data Template, and open the data file.
  4. Go to Studio tab, click on the arrow in Schedule, choose Schedule Local.
  5. In the Automate Scheduler box,:

    1. Choose SAP server for schedule.
    2. In the Title box, type the title you want Studio to show in the list of scheduled tasks.
    3. In the Send Email Notifications To box, type the email address where you want to receive scheduling notifications.

      1. Use commas to separate multiple email addresses.
    4. If you are using an Exchange server to send email notifications and using an Excel or Access data file, 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 Reason box, you can change the reason for the run.
    6. Click Next.
  6. Click One Time, Daily, Weekly, or Monthly.
  7. Choose the recurrence options you want.

    1. 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 Repeat task every box, click 12 Hours, and click 1 Day.
  8. To stop running the scheduled script, check the Expires on box and then enter a date and time.
  9. Click Finish.

Schedule Sever: Schedule on Server with No Data Review process

  1. Launch Excel and open a new blank workbook.
  2. Click the Studio tab and log on to Studio.
  3. Click the Evolve tab, click Open, go to My Template, click Open Transaction Data Template, and open the data file.
  4. Go to Studio tab, click on the arrow in Schedule, choose Schedule Server.
  5. Save the data file to your computer.
  6. In Save to library, edit file name (optional) and click OK.
  7. Select the SAP system.
  8. In the Automate Scheduler box, enter the start date and the start time.
  9. Click Finish.
Note:

Server based posting and scheduling is supported in Studio Manager as well.

Schedule Sever: Schedule on Server with Review and Post - One Step process/ Review and Post - two Step process

After the data file has been submitted and approved, you can schedule the data file run.

  1. Launch Excel and open a new blank workbook.
  2. Click the Studio tab and log on to Studio.
  3. Click the Evolve tab, click Open, go to My Template, click Open Transaction Data Template, and open the data file.
  4. Go to Studio tab, click on the arrow in Schedule, choose Schedule Server.
  5. Select the SAP system.
  6. In the Automate Scheduler box, enter the start date and the start time.
  7. Click Finish.
Note:

Server based posting and scheduling is supported in Studio Manager as well.

For 1 step and 2 step review process for manual run on performing Schedule server action, only one schedule action is allowed. For second attempt, there will be a message guiding that if it is required to edit the scheduled job, it is possible from Evolve/Studio Manager UI if required.

Change the schedule or stop scheduling a run

  1. Click the File tab.
  2. Click Scheduled Tasks.
  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.