
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You could do it using Qlik Sense Repository API,
see the following:

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
OEM Solution Architect
LATAM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nice Adnres,
Didn't know it had something like that, good to know .

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
