Scheduling Integration Runs

Oracle Integration Cloud Service scheduling enables you to schedule the running of integrations configured with trigger and invoke FTP adapter connections. You can schedule these integration runs to copy files at a date and time of your choosing. You can also define the frequency of the integration. When you create an integration with trigger and invoke FTP adapter connections, a schedule icon is displayed with the integration entry on the Integrations page.

For more information about the FTP Adapter see Using the FTP Adapter.

Creating an Integration Schedule

You can create a schedule for running integrations in which trigger FTP adapter and invoke FTP adapter connections are defined.

To create an integration schedule:
  1. Go to the Integration page.
  2. Find the integration in which trigger and invoke FTP adapter connections have been defined.
    These integrations are identified by an Add Schedule icon. There are several ways in which to create an integration.
  3. If you want to first activate the integration and then create the schedule:
    1. Click Activate.
    2. Click Take me to schedule definition after activation, then click Activate.
  4. If you want to first create a schedule for an integration that you activate later:
    1. Click the Add Schedule icon or select Schedule from the dropdown menu at the far right.

  5. Click the Edit icon.
  6. In the Schedule Name field, enter a name for the schedule.
  7. In the Description field, enter a description for the schedule.
  8. When complete, click the green checkmark icon to submit your changes. This action does not save the changes.
  9. In the Frequency section, click the icon to display a dropdown list for selecting the frequency with which to run the integration. As you define one frequency, you can specify additional values by clicking the icon to the right of the Frequency section.
    • Only Once: This is the default selection. This selection clears all settings except for the From field.

    • Hours and Minutes: Specify the hours and minutes at which to run the integration.

    • Days: Specify the days on which to run the integration.

    • Weeks: Specify the weeks during which to run the integration.

    • Months: Specify the months during which to run the integration.

  10. Click the green checkmark icon for each frequency type that you specify.
  11. Click Save to validate your frequency settings.
    Your selections are validated. If there are any errors, a validation message is displayed in the upper left corner that describes how to resolve the errors.
  12. In the Effective section, click the time value to the right of From.
    A menu is displayed for defining the start date of the schedule.
  13. If you want to start the integration run when the schedule is activated:
    1. Click When schedule starts.
  14. If you want to explicitly set an integration run start date:
    1. Select Modify start date.
    2. Click the Calendar icon to select the month, year, and day and the hour, minute, and second at which to start the integration run.
    3. Click OK.
  15. In the Expire section, click the link to the right.
    A menu is displayed for defining the expiration date.
  16. If you want the schedule run to never expire:
    1. Select Never (repeat indefinitely).
  17. If you want the integration run to have a fixed expiration date:
    1. Select Choose expiry date.
    2. Click the Calendar icon to select the month, year, and day and the hour, minute, and second at which to end the integration run.
    3. Click OK.
  18. Click Save.
    If successful, a message is displayed in the upper left corner.
    Schedule Run: name saved successfully..
    
  19. Click Exit Scheduler.
    The Schedule and Future Runs page is displayed and the Monitoring tab is highlighted in the upper right corner.
  20. If you have already started the integration, click Submit Now to run the integration or Start Schedule to activate the integration schedule.
  21. If you have not yet started the integration, return to the Integrations page and click Activate.
  22. Click the Add Schedule icon or select Schedule from the dropdown menu at the far right to return to the Schedule and Future Runs page.
  23. Click Submit Now to run the integration or Start Schedule to activate the integration schedule.

Starting and Pausing an Integration Schedule

After you define a schedule, you must activate it. You can also pause (deactivate) a schedule, as needed.

To start and pause an integration schedule:
  1. Go to the Integration page.
  2. Find the integration on which the scheduled run is defined.
  3. Click the Add Schedule icon or select Schedule from the menu at the right. Once a schedule is defined, the tooltip for this icon is changed to Schedule Defined.
    The Schedule and Future Runs page is displayed.
  4. Click the Start Schedule button.
    The following message is displayed at the top of the page: Schedule is now active.
    Details about the schedule including the frequency and any expiration date are displayed. The Start Schedule button is changed to Pause Schedule.
  5. If you want to pause the schedule run, click Pause Schedule at the far right.
  6. If you want to resume the schedule run, click Resume Schedule. This toggles the button name to Pause Schedule.

Viewing Past and Present Integration Runs

You can view the status of past and present scheduled integration runs.

To view past and present integration runs:
  1. Go to the Integration page.
  2. Find the integration on which the scheduled run is defined.
  3. Click the Add Schedule icon or select Schedule from the menu at the right.
    The Schedule and Future Runs page is displayed.
  4. Click View Past Runs.
    The Past Runs page is displayed. By default, all integration runs are displayed.
    Description of GUID-4FA38FE3-37DE-4F3C-AE44-86B233E44904-default.png follows
    Description of the illustration GUID-4FA38FE3-37DE-4F3C-AE44-86B233E44904-default.png
  5. Filter the display of integrations:
    1. Click In Progress to display all integration runs currently in progress.
    2. Click Completed to display all completed integration runs.
    3. Click the dropdown list to filter the display of runs by 1 hour, 6 hours, 1 day, 2 days, or 3 days.
  6. If a schedule run has failed (for example, the target FTP server did not have the correct write permissions), click the Resubmit icon at the far right to resubmit the schedule run.
    This action creates a RESUBMITTED RUN ID: number message to the right of the schedule name and original run ID. If you resubmit again, you end up with the following messages to the right of the schedule name:
    • RUN ID: number: The run ID for the first resubmission, which failed.

    • RESUBMITTED RUN ID: number: The run ID for the latest submission.

    • ORIGINAL RUN ID: number: The run ID for the initial submission.

  7. Click the RESUBMITTED RUN ID: number message link to go to the Tracking page.
  8. Click the file name of the instance.
    A graphical view of the integration flow is displayed.
    For example, if the resubmission resulted in a failure, details are displayed. For this example, the write portion of the integration failed because of a permissions issue.
    Description of GUID-F129AA55-A0D3-4711-912B-829E922AAC09-default.png follows
    Description of the illustration GUID-F129AA55-A0D3-4711-912B-829E922AAC09-default.png
  9. Select Actions > Audit Trail to view specific details about the error, such as the target directory not being defined with write permissions.

Viewing Future Runs

You can view the status of future scheduled integration runs.

To view future runs:
  1. Go to the Integration page.
  2. Find the integration on which the scheduled run is defined.
  3. Click the Add Schedule icon or select Schedule from the menu at the right.
    The Schedule and Future Runs page is displayed.
  4. Click View Past Runs.
  5. Click View Schedule.

    Details about the future runs are displayed.

Editing an Integration Schedule

You can edit a schedule for an integration run.

To edit an integration schedule:
  1. Go to the Integration page.
  2. Find the integration on which the scheduled run is defined.
  3. Click the Add Schedule icon or select Schedule from the menu at the right.
    The Schedule and Future Runs page is displayed.
  4. On the far right, click the Edit icon.
    Description of GUID-AE4EC4DC-CC90-4AC7-B0C4-19F91FF2A8E6-default.png follows
    Description of the illustration GUID-AE4EC4DC-CC90-4AC7-B0C4-19F91FF2A8E6-default.png
  5. Edit the schedule. For information about the fields you can edit, see Creating an Integration Schedule.
  6. Click Save.

Deleting an Integration Schedule

You can delete a schedule for an integration run.

To delete an integration schedule:
  1. Go to the Integration page.
  2. Find the integration on which the scheduler run is defined.
  3. Click the Add Schedule icon or select Schedule from the menu at the right.
    The Schedule and Future Runs page is displayed.
  4. Find the schedule in the list that you want to delete.
  5. On the far right, click the Delete icon.
    Description of GUID-AE4EC4DC-CC90-4AC7-B0C4-19F91FF2A8E6-default.png follows
    Description of the illustration GUID-AE4EC4DC-CC90-4AC7-B0C4-19F91FF2A8E6-default.png
  6. Click Yes when prompted to confirm.

Monitoring Integration Runs

You can stop and restart scheduled runs for an integration from the Monitoring page.

To monitor integration runs:
  1. On the Integration Cloud Service toolbar, click Monitoring.
  2. In the navigator, click Integrations.
    For integrations that include source and target FTP adapter connections, the calendar icon is displayed. This page shows only active integrations. Integrations can be of any type (that is, with or without the FTP Adapter).
  3. If you want to restart scheduled runs of an integration, click Resume Schedule.
  4. If you want to stop scheduled runs of an integration, click Pause Schedule.