Qlik Sense Task

[kamielrajaram]

Hi all,

I would like to find out if it is possible to execute a Qlik Sense task once a SQL job has been executed.

Thank you

Kind Regards

Kamiel

[felipedl]

You could do it using Qlik Sense Repository API,

see the following:

Task: Start by name asynchronously ‒ Qlik Sense Developers

[MK9885]

It depends how you'd like to run the task based on your SQL job.

I usually run my task only if the load in DB is complete, for that I've created a view in db.

By creating a loop script in your qvf and having other tasks dependent on the loop file. If the load is successful, your task would start, save the qvd with new time stamp.

There is more to it.... not sure if you looking for this?

[Ricardo_Gerhard]

Dear Kamiel,

   I already configure a job who runs continuously/each 5 minutos and detect a field like "updated=yes" then run the load script. Just check on SQL Server workflow a possibility to add a new step like run a batch job.

[kamielrajaram]

Hi,

Yes, this would be a a great start. Please can you elaborate and provide an example of the view and loop script.

Thank you .

Regards

Kamiel

[andrespa]

Complementing what Felip said, you can use this very useful  powershell wrap by Adam Haydon to prepare your script:

GitHub - ahaydon/Qlik-Cli: Qlik Sense Cmdlet for PowerShell

Hope it helps,

Andrés

[felipedl]

Nice Adnres,

Didn't know it had something like that, good to know .

[kamielrajaram]

Hi,

Thank you. I am not to familiar with powershell. How do I go about getting the task to reload once the sql job has completed.

Thank you

Kamiel

[awhitfield]

When you say SQL job, do you mean and Scheduled SQL agent job? If so can you not look at the task history of week the schedule runs and how long it takes and create a task schedule for the Reload task that mirrors that with a buff of nnn minute greater that the SQL job max run time?

best regards

Andy