topic Re: Task Trigger on Checking DB in QlikView

Task Trigger on Checking DB

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Hope you are doing good.

Can anyone plz help me to implement this.

I have table CountData, I want to check the count of record in that table. If the count is 0, then Qlik Task will be triggered.

This checking will happen for 3 hours. Lets say 7 AM to 10 AM. in this time frame whenever the count become 0, Qlik Task will be triggered.

Thanks,

Re: Task Trigger on Checking DB

mrtinsjoao — Wed, 17 Jul 2019 20:24:18 GMT

You can automatizate the reload with windows task scheduler or a qlikview server. With you don't have a qlikview server, use the task scheduler to automatizate the process what you want.
Pull the trigger on the schedule e put this code in the respective matches.
"C:\Program Files\QlikView\Qv.exe" /r "C:\Qlik\Comercial.qvw"
i think you can do it.

João Martins

Re: Task Trigger on Checking DB

mhmmd_srf — Wed, 17 Jul 2019 20:46:33 GMT

Thanks Martin.

But how to make this dependent on the count value of the table.

I need to find

select count(*) from table.

If this is = 0, then only will trigger, else not.

Can u plz suggest.

Thanks,

Re: Task Trigger on Checking DB

Brett_Bleess — Mon, 12 Aug 2019 21:35:38 GMT

I may have a better idea here. There is a new feature in November 2018/12.30 track related to Publisher Tasks, which is the File Exists task. I am thinking you could use that and in the app where you are trying to do the countdown, all you really need to do is say if the variable or whatever is 0 there, then run CMD.exe /c and write Go.txt or whatever to specified location the File Exists task is checking such that it can see it and trigger the task for you, the trick is you will need another task after that to delete the Go.txt file, or that other task will keep triggering...

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/QMC/Content/QV_QMC/QMC_System_SupportingTasks_ExternalPrograms_General.htm

Scroll down to the File Exists section... Hopefully this may provide an alternative that is a little easier.

Regards,
Brett