When a task enabled for SQL ELT optimization is running, you can clean stop the job to
terminate all the issued statements and processes spawned by the job.
Use the
Clean Stop
option on the My Jobs page in Data Integration and the All Jobs and
Running Jobs page in Monitor.
See the following exceptions before you clean stop a SQL ELT optimization task:
When you clean stop a task enabled for
source SQL ELT optimization that reads from or writes to Databricks and the
target or source properties in the mapping contains pre-SQL or post-SQL
statements, even if the select query is terminated, the job continues to run the
target post-SQL query.
When you start a job enabled for full
SQL ELT optimization and clean stop it immediately, and if the mapping is
configured to create a new target at runtime, Data Integration creates the table
even if the job is terminated.
ASK INFAPreview
