I have a job which is is using an email trigger.

The process is

1) Run SQL script
2) Email result to "someone@somewhere.com ; {TRIGGER(Active,LastTrigger,Mail.Result.Mail.FromAddress)}"

The last part being the email address of the email which caused the job to run.


The problem is that, if I run the job manually, it remembers the last value from the "..... mail.result.... etc..." and send the email again to that user.

Is there anyway to avoid this ?


Graham

The Last Trigger Variable should be unique for each call. We have to investigate and test this.

---