How to create a ticket rule for After Hours tickets?
I have looked through the site as best I can and found a few articles that are similar, but nothing that covers exactly what I'm asking.... I manage our companies Support Desk M-F 8-5 but after I leave and on the weekends the system is not monitored very closely. I need to have the system setup so any tickets that come in when I am not available are automatically get assigned a Priority of "After Hours" (already part of my list) and then automatically generate an email to specific staff members.
I'm thinking the SQL needs to say something like this in the select statement:
DATE_FORMAT(HD_TICKET.CREATED,'%b %d %Y %I:%i:%s %p') as CREATED
Then have something in the WHERE clause like
Where CREATED > "17:00:00" OR CREATED < "08:00:00"
But I have no clue... can someone help me out with the code? The email to the staff members doesn't need to have much detail aside from the ticket number, who the submitter is, and most recent comment.