topic Email notification on reload failure in QlikView

Email notification on reload failure

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

Is it possible to send a notification via SMTP to an email address for specific tasks?

The QMC enables you to set up SMTP recipients if there is a failure of ANY task. I want to notify an individual only if certain tasks fail.

Many thanks.

Email notification on reload failure

Mon, 07 Dec 2009 16:46:00 GMT

You can monitor within the load script for errors and send an email as required.

First of all you need to have set the 'Mail' settings for the 'User Preferences' .

Next, if you want to monitor certain statements, set monitoring on/off so that the load continues. For example:

before script lines to be monitored

SET ErrorMode=0; // ignore any script errors

......(script lines)

after loads script lines to be monitored

SET ErrorMode=1; // reset to default (halt and prompt)

Create an alert to be triggered if scriperrorcount <> 0. Note that mode is set off for interactive. With this checked a pop-up occurs with the plugin to ask if the email should be sent (I use v8.20 - is this a bug?)

Add a text object to display a suitable message (Layout> Show > Conditional 'ScriptErrorCount <> 0') in case of errors when interactive reload has been performed (which will not fire the alert)

Hope this helps!

Gordon

Email notification on reload failure

prieper — Mon, 07 Dec 2009 16:56:48 GMT

Each application has - after refresh - the possibility to send email subject to certain conditions met. In order to supervise your applications, you may turn on the logfiles and build an application to read all logfiles, whether refreshed in time (you may also create your own alert-messages, subj to certain conditions met) and timestamps, when it was refreshed the last time.

Peter

Email notification on reload failure

Fri, 14 May 2010 14:15:34 GMT

Hi,

I could not find the window which is on this screenshot.

Could you explain, where is that alert settings?

Email notification on reload failure

Thu, 20 May 2010 06:44:54 GMT

I can not find that 'Mail' settings and the 'User Preferences'

Email notification on reload failure

Thu, 20 May 2010 08:02:02 GMT

It is under 'Settings' menu.

Email notification on reload failure

Thu, 20 May 2010 08:22:47 GMT

I go to settings => User Preferences than that user preferences is shown. But it is different from gordons.

Email notification on reload failure

Thu, 20 May 2010 08:30:13 GMT

That is alert tab where it is in tools menu.In mail tab you will be explained the defaults of your mail settings and after that you will create an alert for your document from alert tab.

Email notification on reload failure

Fri, 10 Sep 2010 17:35:51 GMT

This thread was very useful! Thanks Everyone!

Now one other quick question along the same lines. One other problem we are having is if the file is taking a long time to run we would like to recieve an email. For example, if we know a file takes approx 5 minutes to normally reload, but on a particular reload it has been running for over 30 minutes- would there be a way to be notified??

Email notification on reload failure

Thu, 22 Sep 2011 14:27:39 GMT

I have followed all your tips but no mail was sent; otherwise if i tick 'On open' a mail was succesfully sent (due to that i can exclude any connection problems). I'm using QlikView Desktop 10 SR3.

Any ideas?

Thanks..

Matteo A.