K1000 rule:Open a ticket automatically
I dont know if it is able but what i want is an automatically ticket from monday to friday at 15:30 in one of my queues.
I know that i have to select the email address of my servicedesk and send there the notification, in this way it will open a ticket, but what i dont figure out is the rest of the field and tables that i have to select, if i have to select any.
my code doest give me errors, but it doesnt send any email at all.
select 1, 'email@example.com' as email_servicedesk
where curtime() = '15:30:00'
and DAYNAME(NOW()) NOT IN ('Saturday','Sunday') /* not the weekend */
->checkbox sending email
Coluna contendo endereços de e-mail: email_servicedesk
There are no answers at this time