System Queue Rule: Email on Close
Hi All, I am trying to set up a system queue rule to send an email to the submitter of a ticket the moment that ticket is closed. The purpose of this is for the user to be able to see the resolution in the email to verify that the resolution is what they required. Does anyone have a working example of this? I am not well versed in sql/mysql so I have been working on a rule, but cannot get it to work. The log just keeps saying
06:40> Starting: Mon, 23 Apr 2012 10:06:40 -0400
06:40> Executing Select Query...
and the last line never shows anything else. Any help troubleshooting why it might be doing that or a working rule would be very much appreciated!