Skip to main content

Scheduling Execution Packages in Jet Analytics Orchestration

Note: This article is intended for database administrators. Ensure the following tasks are completed by someone with the appropriate database administration privileges.

Jobs have been deprecated. Schedule Jet Analytics Data Integration execution packages via Jet Analytics Orchestration as described in this article, rather than using jobs.

Note:

This functionality was released in Jet Analytics Data Integration 6814.1 and requires Jet Analytics Orchestration and Data Quality version 24.3 or later.

Instead of managing Jet Analytics Data Integration executions as Jobs, tasks and execution packages can be orchestrated directly. This eliminates redundant groupings, making setup easier and more intuitive. Jet Analytics Orchestration provides real-time command execution — when you click Run, executions start immediately. All log details, execution statuses, error messages, and task logs are available in one place.

Prerequisites

  1. Get access to Jet Analytics Orchestration:
    • Go to the waffle menu in the top right corner of the Jet Analytics Portal.

    • Click Unlock Orchestration.
    • Select which user should be the account admin in Jet Analytics Orchestration.
    • Click the Unlock Orchestration button.
  2. Create an API Key.
  3. The Jet Analytics Execution Service must be running and configured to allow Jet Analytics Orchestration to run packages. See Configure the Execution Service for more information.

Schedule an execution in Jet Analytics Orchestration

Note:

When requesting access to Jet Analytics Orchestration as described in step 1 of the prerequisites, an API key and a Data Provider are auto-generated during the creation process, so you can get started immediately. If you prefer not to use the auto-generated key, you can generate a new one from the Jet Analytics Portal at any time.

  1. Add a Jet Analytics Data Integration Data Provider in Jet Analytics Orchestration using your API key:
    • Right-click Data Providers under General in the Object Explorer.
    • Select New… > Data Provider.
    • Provide a title and click OK.
    • Click Datasource Type and select Jet Analytics Data Integration.
    • Paste your API key into the API key field in the connection pane, save it, and click Sync with Jet Analytics Data Integration…
    • Select a system to create or move tasks to and click OK.
    • Refresh the Object Explorer.
  2. Add Ingest tasks and Prepare or Deliver execution packages in Jet Analytics Orchestration:  
    • Right-click Packages.
    • Select New… > Jet Analytics Ingest, Jet Analytics Prepare, or Jet Analytics Deliver as appropriate.
    • Give the package a name.
    • Select the Data Provider created in step 1.
    • Save the package.

    • Test by clicking the Run button and then Run Task. Scheduling Objects in Jet AnalyticsOrchestration

  3. Schedule the execution using a Schedule Group. See Schedule Objects for more information.
    • Right-click Schedule Groups in the Object Explorer and select New… > Schedule Group.
    • Drag the Jet Analytics Ingest, Prepare, or Deliver packages into the Schedule Group.
    • Select whether they should run in Sequence or Parallel.
    • Configure the schedule in the Trigger pane and click Save.

Note:

When scheduling Deliver executions, the default execution package is not synced to Jet Analytics Orchestration. You must create a separate, named execution package — only non-default packages are synced and available for scheduling.

Execution history

To view all execution log details:

  1. Open Jet Analytics Orchestration.
  2. Navigate to General > Audit History in the Object Explorer and select Execution History.

  3. Click the i icon on the right-hand side of the relevant package to view execution details and the full Jet Analytics Data Integration logs.

Seamless navigation

A navigation button in Jet Analytics Data Integration opens Jet Analytics Orchestration directly.

Note:

The Jet Analytics Orchestration navigation button is displayed only when Jet Analytics Data Integration and Jet Analytics Orchestration are installed on the same machine.

Parallel executions of execution packages

Parallel execution of non-dependent packages within the same instance

When working with multiple non-dependent packages — that is, packages that do not contain the same objects — these can run in parallel by configuring concurrent packages. Edit your execution package, go to the Concurrent packages tab, and select which packages can run concurrently.

Parallel execution of packages in different Prepare instances

To execute packages in different Prepare instances in parallel, drag the Jet Analytics Prepare packages into the Schedule Group and ensure the Parallel property is set to Parallel.

Parallel execution of packages in different Deliver instances

To execute packages in different Deliver instances in parallel, drag the Jet Analytics Deliver packages into the Schedule Group and ensure the Parallel property is set to Parallel.

Note:

This requires configuring the Max degree of Deliver instance parallelism setting in the Jet Analytics Execution Service. This setting controls how many Deliver instances can execute simultaneously. You can also set up multiple VMs each with an Execution Service, and configure each to handle specific Deliver instance executions.

Troubleshooting

For troubleshooting issues related to scheduled Jet Analytics Data Integration executions in Jet Analytics Orchestration, see the Jet Analytics Orchestration troubleshooting documentation.

Was this article helpful?

We're sorry to hear that.