I am required to send mails to a particular mailing list which is populated by a simple select query in sql server. This is required to be done every day at 8:30 am. So I am required to create a job in Control M. Can anyone provide me with some pointers regarding this , as I am new to Control M. Can I send mails from Control M to dynamic mailing list which is populated by Sql query? Is it also possible to have a attachment while sending the mail from Control M?
Thanks in advance.