Use script Parameters or messages in an Alert email body

Anonymous — Tue, 16 Feb 2016 00:28:54 GMT

Hi - I've set up Email Alerts for a script that runs on my desktop each morning. The scrip extracts several parameters from our data wharehouse to store as QVDs.

At current, the script is set to fire an email if the script errors at any point, accomplished by setting the Condition as ScriptErrorCount > 0.

What would be great is if the email can send a parameter or some sort of output from the script to tell me what part has failed. I've tried to put these sort of things in the Alert message, but it just outputs everything as text unless I only specify the variable (ie. I can't combine freetext and variable).

Is this possible ?

If so, how do I declare multiple variables ?

Idea in the script itself would be

Metric 1:

Load etc,,,

if ScriptError = 0

then

Let Metric1Error = 1

Metric 2:

Load etc,,,

if ScriptError = 0

then

Let Metric2Error = 1

topic Use script Parameters or messages in an Alert email body in QlikView

Use script Parameters or messages in an Alert email body