An email will have been sent from one of two places, a batch job or a workflow.
📌 Note: Some batch jobs are scheduled to run workflows which may send an email.
Requirements
The name of the person who received the notification/e-mail.
The date and time the email was received.
The header text of the email and body (whole copy of the actual email is even better).
Check if an email has been sent via a batch job
To check if the email has been sent via batch job, follow these steps.
Create a new export- logging into the SelectSystem Database.
Copy the following SQL to your clipboard.
Click Options.
Click Paste SQL from Clipboard:
Select Batch.Messages.Subject, Batch.Jobs.Description, Batch.Jobs.[Job Name], Batch.Jobs.[Job Number] From Batch.Messages Inner Join Batch.Jobs On Batch.Jobs.[Job Number] = Batch.Messages.[Job Number] Where Batch.Messages.Subject Like '%REPLACE WITH SUBJECT%'
This export will check the batch jobs for a configured email as it appears in the batch job configuration screen.
Check if an email has been sent via a workflow
To check if the email has been sent via workflow, follow the steps below.
Create a new Export- logging into the SelectSystem Database.
Copy the following SQL to your clipboard.
Click Options.
Click Paste SQL from Clipboard:
Select Batch.Jobs.[Job Name], Batch.Workflows.[Workflow Number], Workflow.MessagingActivities.[Workflow Name], Workflow.MessagingActivities.Subject, Workflow.MessagingActivities.Body From Batch.Jobs Right Join Batch.Workflows On Batch.Jobs.[Job Number] = Batch.Workflows.[Job Number] Right Join Workflow.MessagingActivities On Batch.Workflows.[Workflow Number] = Workflow.MessagingActivities.[Workflow Number] Where Workflow.MessagingActivities.Subject Like '%REPLACE WITH SUBJECT%'
This export will check workflows related to batch jobs for a configured email stage.
📌 Note: If the email is sent using any kind of data for the employee like their name then you will need to adapt the query for this.
E.g An employee has received an email which has the subject reading as "Absence request for John Doe for 18th Dec".
Your query in the criteria column of the export should read as Like 'Absence request for%' to ensure the name and date do not interfere.