Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kamielrajaram
Creator III
Creator III

Qlik Sense Task

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

8 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

You could do it using Qlik Sense Repository API,

see the following:

Task: Start by name asynchronously ‒ Qlik Sense Developers

MK9885
Master II
Master II

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
Employee
Employee

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.

Ricardo Gerhard
OEM Solution Architect
LATAM
kamielrajaram
Creator III
Creator III
Author

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
Specialist
Specialist

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
Partner - Specialist III
Partner - Specialist III

Nice Adnres,

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

kamielrajaram
Creator III
Creator III
Author

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
Partner - Champion
Partner - Champion

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