topic Re: Task status on Control Tables in Qlik Replicate

Task status on Control Tables

Al_gar — Sat, 18 Jan 2025 22:06:43 GMT

Is there any control table in Qlik Replicate Nov 2023 (2023.11.0.159) that has the status or state of a full load task? Looking to create a stored procedure around a particular task state (e.g. Completed, Failed, Running) without having to go to the EM API.

Re: Task status on Control Tables

Shai_E — Mon, 20 Jan 2025 13:43:07 GMT

Hi @Al_gar

There are two control tables that might interest you

Replication status #Replication status | Qlik Replicate Help

Replication history #Replication history | Qlik Replicate Help

As for a state column i assume you mean if the task is in error state or not, i am not sure if either of those tables has such a column.

Best Regards

Re: Task status on Control Tables

DesmondWOO — Tue, 21 Jan 2025 08:28:53 GMT

Hi @Al_gar ,

Please check the following command to see if it is helpful.

repctl connect; gettaskstatus <TASK NAME>; disconnect;

Regards,
Desmond

Re: Task status on Control Tables

Al_gar — Mon, 27 Jan 2025 13:36:00 GMT

Thanks, but these tables control tables are not created when using Full Load only tasks.

Re: Task status on Control Tables

Shai_E — Mon, 27 Jan 2025 13:44:29 GMT

Hi @Al_gar

Then i advise on trying @DesmondWOO , repctl command.

Best Regards

Re: Task status on Control Tables

Al_gar — Mon, 27 Jan 2025 13:50:06 GMT

Hi @DesmondWOO,

We thought about using this Replicate's repctl command, but the idea is to use only a stored procedure to query a status table. We were hoping to get a similar Task History information as the one found in the Monitor Tab > History section:

Going to check if there's any Ideation post for this particular.