Skip to main content

Data Export: Email recipients for batch job messages

Data export to show who receives the emails from each batch job.

Written by Harry Ledger

To find who is set up to receive emails from each batch job, follow the steps below.

  1. In the Admin Tool, click Import/Export Data.

  2. Click Create an export definition.

  3. Click Select the data to export.

  4. Change the database to SelectSystem.

  5. Log in.

  6. Copy the below SQL:

    Select Batch.Messages.*, Batch.[Message Recipients].[Email Address] From Batch.Messages Inner Join Batch.[Message Recipients] On Batch.Messages.[Message Job Number] = Batch.[Message Recipients].[Message Job Number]
  7. In the top left of the data export window, click Options, Paste SQL from clipboard.

  8. Click Query.

  9. Click Data.

Did this answer your question?