Software Deployment Question
K1000 rule:Open a ticket automatically
12/17/2014 1637 views
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, 'firstname.lastname@example.org' 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
Be the first to answer this question