Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kamielrajaram
Contributor 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
Valued Contributor III

Re: Qlik Sense Task

You could do it using Qlik Sense Repository API,

see the following:

Task: Start by name asynchronously ‒ Qlik Sense Developers

arvind654
Honored Contributor II

Re: Qlik Sense Task

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?

dcj
Valued Contributor II

Re: Qlik Sense Task

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
Contributor III

Re: Qlik Sense Task

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
Valued Contributor

Re: Qlik Sense Task

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
Valued Contributor III

Re: Qlik Sense Task

Nice Adnres,

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

kamielrajaram
Contributor III

Re: Qlik Sense Task

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
Esteemed Contributor

Re: Qlik Sense Task

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