topic Re: External Program Task in Qlik Automate

External Program Task

wallace0834 — Thu, 22 Sep 2022 20:08:05 GMT

I am needing to create an External Program Task that will send automatic email when several schedule task chains have completed. The e-mail is sent with the name of the task schedule the date and the body of task completed. I have already completed building the task called Send Email Message.

I would appreciate any insight that you can provide to me.

Re: External Program Task

RafaelBarrios — Thu, 22 Sep 2022 20:38:02 GMT

Hi @wallace0834

If what you need is to be able to create the task in Qlik Sense QMC and then trigger it, I think you need to upgrade to May2021. It introduce an option to call a .bat o powershell file when configuring the task

https://help.qlik.com/en-US/sense-admin/May2021/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Administer_QSEoW/Managing_QSEoW/create-edit-external-program-tasks.htm

I started using it in feb2022 and works fine, don’t know how it works en may2021

Best,

Re: External Program Task

wallace0834 — Fri, 23 Sep 2022 17:57:21 GMT

Thanks. We are using Qlik Sense May 2021 in a multi-node environment.

Re: External Program Task

RafaelBarrios — Sat, 24 Sep 2022 07:50:35 GMT

Hi @wallace0834

Here you have an example

This one uses node to execute a .js file that makes copies of a template app. (Similar to qlikview publisher)

I Best,

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs

Re: External Program Task

wallace0834 — Fri, 07 Oct 2022 18:37:37 GMT

We are running Qlik Sense 2021. Any otter suggestion, would you recommend.

Re: External Program Task

wallace0834 — Fri, 07 Oct 2022 18:40:55 GMT

Here is example of my picture down below.

Re: External Program Task

RafaelBarrios — Fri, 07 Oct 2022 19:37:21 GMT

Hi @wallace0834

you should be able to do so in may2021 version

https://help.qlik.com/en-US/sense-admin/May2021/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Administer_QSEoW/Managing_QSEoW/create-edit-external-program-tasks.htm

in older versions wouldn’t be that easy but can be done using the API

https://community.qlik.com/t5/Official-Support-Articles/How-to-create-an-external-program-task-in-Qlik-Sense-with-a/ta-p/1713044

Best,

Re: External Program Task

RafaelBarrios — Fri, 07 Oct 2022 19:39:36 GMT

But you got it !!!

what problem you are having?

Re: External Program Task

wallace0834 — Mon, 10 Oct 2022 20:34:51 GMT

When I execute the script in PowerShell, it works great. When I created External Program and link it to a schedule task, it sends multiple e-mail instead of just one. Could you please provide any suggestion on how to fix it?

Re: External Program Task

wallace0834 — Mon, 10 Oct 2022 20:34:04 GMT

Re: External Program Task

RafaelBarrios — Tue, 11 Oct 2022 07:35:44 GMT

Hi @wallace0834

I guess this list of triggers corresponds to your new external task.
so, this task executes everytime any of the other task finish (i cant see if the condition is that this previous task executes succesfully or not).

Also, i see SentEmail as trigger and if the task calls itself as a trigger, you may be doing a circular reload.

Best,

Re: External Program Task

wallace0834 — Fri, 14 Oct 2022 13:05:16 GMT

My powershell script is working as it should. I had created External Program to link it or reference my PowerShell script. I had attached the last schedule task chain to my (External Program) call Send e-mail me and it worked flawlessly.

Re: External Program Task

binitafelicity — Wed, 19 Oct 2022 07:59:58 GMT

With external program tasks, you can trigger external processes, such as scripts or .exe files. Task chaining is supported and you cps-tester.co can combine reload tasks ...External program tasks in Qlik Sense are simply another task type. With external program tasks, you can trigger external processes, ...External Tasks are stored details of tasks that are run as part of OEDQ Jobs, but which do not occur within the OEDQ application. An External Task may be either ...

Re: External Program Task

Cristian_Dorbesi — Thu, 16 Nov 2023 20:42:01 GMT

Hello,

Have anyone tried and succeded to execute an external task (eg. a BAT file) that is located on a network path (using IP of course, not the mounted drive)?
I'm not able to trigger even a simple 'echo blabla > c:\temp\test.log'

The bat file works fine when double clicking or when placed on 'c' drive, but as soon as I place .bat on a network path it stop working. Any idea why?
All testing was made using the user running the QS services.

Thanks!