Configuration of Action question

[DonnEdwards]

Please have a look at the Action below.

What I want it to do is send an email when the SQL Service goes down, i.e. when {ITEM.LASTVALUE} > 0
I want it to use the first message, with the subject

MSSQLSERVER service is DOWN on {HOSTNAME}

If {ITEM.LASTVALUE} returns to 0, I want it to use the recovery message, i.e.

MSSQLSERVER service is UP

What is happening is that when {ITEM.LASTVALUE} returns to 0 the first message is sent again.

So where am I going wrong? Any advice will be appreciated.

The second graphic shows the Trigger setup.

[marcel]

action condition needs to contain "Trigger value = PROBLEM"

[DonnEdwards]

Many thanks. It works like a charm.