Skip to main content

Data Export: Email recipients for batch job messages

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

H
Written by Harry Ledger
Updated over a month ago

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?