Task status on Control Tables

[Al_gar]

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.

[Shai_E]

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

[DesmondWOO]

Hi @Al_gar ,

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

repctl connect; gettaskstatus <TASK NAME>; disconnect;

Regards,
Desmond

[Al_gar]

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

[Shai_E]

Hi @Al_gar 

Then i advise on trying @DesmondWOO , repctl command.

Best Regards

[Al_gar]

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.