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.
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
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!
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.
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.
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??
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.