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!