Let's explore the possibilities of scheduling tasks in SAP Datasphere.
Task Chains
You can create a task chain to add various tasks and run them manually once, or periodically through a schedule.
Task chain scheduling may include execution of:
- Remote table replication, view persistence, and intelligent lookup.
- Remove replicated remote table data or persisted view data.
- Data flow, replication flow (initial only), and transformation flow runs.
- Other task chains (nested) and shared task chains.
- Call external (RESTful) APIs via HTTP(s) connections.
- SQL procedures (Open SQL Schema), notification tasks.
Using task chains offers the following features:
- Serial and parallel processing are supported with ALL or ANY operators.
- Customizable email notification of success and/or failure of entire task chains.
- Build global task chains using cross-space sharing including input parameter support.
- Export and import of task chains using CSN/JSON file definitions.
- Create, manage, pause, and run schedules using simple time settings or advanced CRON expressions, with the ability to retry failed tasks within nested chains (deep retry).
- Scheduled tasks are executed asynchronously and recurrently in the background according to the defined schedule (frequency: minutes, hourly, daily, weekly, monthly). Tasks can be scheduled according to a preferred time zone with automatic daylight saving adjustments.