Data reload only if SQL server agent successful?

[user467341]

Hi, I have a Qlik Sense dashboard that has a scheduled task loading of data from a SQL Server database. The data inside this database is updated via SQL server agent.

Sometime, the SQL server agent job may fail due to some reasons and this caused the table to be outdated. However, Qlik Sense will not know that the SQL server agent failed and will just continue to perform the scheduled task data reload.

My question is how can I config the scheduled task to check if the SQL server agent has successfully completed the run? I do not want the data reload in Qlik Sense to run if the SQL server agent failed.

[Anil_Babu_Samineni]

I have used this tool to build on success of SQL, https://github.com/marcusspitzmiller/QlikSenseTask

It means, You have to find or get a variable of last table reload time, with that you can create powershell script to get trigger Qlik sense.