i need to send an email to a group of users, AFTER the job is executed, where i need to list lines from log in the email body.
So here are two potential problems, where i can use some suggestions:
1 - i can't add a task to run after the main task of the job, because the BatchHistory table (thats where the info lines live) is committed after the job has finished.
2- there is an alert option, which would sent email to the user that the job is done, but then i would need to customize the body of the email message that was set up as a template for an alert - which i still cant figure out how...
any ideas will be appreciated, thanks
If you've found this thread useful, dive deeper into User Group community content by role