Email when Job completes successfully

[smithla2]

I need to send an email notice to a distribution group when a Job schedule ends, indicating a metric rebuild has occurred.  My understanding is Event Studio querying the audit db is a good method to accomplish this task.

First, if there is a better approach to sending this email notification, please enlighten me.

I've been scrubbing audit db tables, COGIPF_RUNJOB and COGIPF_ACTION in particular.  Filtering on COGIPF_JOBPATH to select desired Job and tables are joined by COGIPF_SESSIONID and COGIPF_REQUESTID.  My queries return multiple rows of data and unable to identify criteria to report successful completion of the Job.

Are there other tables I should include in my query to accomplish the task?

Thank You!