Disable Qlik Compose Tasks

[RPANICHER]

Hi,

We have full load tasks and delta load tasks in Qlik Compose.

Since the full load tasks are already run we would like to disable them so that nobody will run it by mistake.

Is it possible to disable a task & only enable it when required.

Kind Regards

RP

[SushilKumar]

Hello @RPANICHER 

Request you to Follow below Qlik Help Document for further instruction .

https://help.qlik.com/en-US/compose/May2022/Content/ComposeDWDL/Main/DW/Tasks%20and%20Workflows/cont...

Regards,

Sushil Kumar

[RPANICHER]

Hi Sushil,

I could not find the answer to my question in that URL.

Can you point me to the relevant section in that document.

Kind Regards

RP

[sureshkumar]

Hello @RPANICHER 

I don't think we have to option to disable the Full load because 2 separate tasks will be created one for Full load and another for CDC.

For example Task SRC -FL and SRC_CDC - CDC

If you're in 2023.11.0.343 (Service Patch 5), there is an option to change to Type either Full Load Or Change Processing.

Hope it helps.

Regards,

Suresh

[TimGarrod · Accepted solution]

Another option if you wish to ensure the full load task does not run would be to configure a Pre-Load step for the task.  This could simply be anything that would fail. 
E.g. in SQL Server you could perform a RAISEERROR(16,1, 'Full load tasks should not be run unless absolutely necessary'). 

You could tag the Pre-Load task to every full load task and generate and remove it when you want to actually run the full load task.

[RPANICHER]

Thx, TimGarrod

Since Qlik Replicate does not have an option to enable/disable tasks, your workaround is the best option.

[kenamm]

we used to use Azure SQL Managed Instance and have since moved everything off - largely because of the inability to turn off logging, and also the log throughput limit which ultimately puts a bottleneck on everything on larger workloads. Check you logs and see if that's the problem.

Its fundamentally not built for larger DW workloads.