I have the following problem:
A user performs a test X step, when he clicks to get the first result, he must create 9 e-mail messages to be sent to the logo of 3 days, morning (7:00), afternoon (13: 00) and the night (21:00). The question is how can I set the 3 schedules? Dates have already been achieved.
My scheduling table has the following structure:
CREATE TABLE maas_emails_agendados (
email_id int(11) NOT NULL auto_increment,
email_destinatario_nome varchar(255) default NULL,
email_destinatario varchar(255) default NULL,
email_assunto varchar(255) default NULL,
email_mensagem text,
email_agendamento datetime default NULL,
cliente_id int(11) default NULL,
PRIMARY KEY (email_id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;