I am using Centerprise 8.5.4.172 and I am looking to see if I can generate a daily export (for instance, to Excel) of all failed/errored jobs.
The problem I am running into is that when I apply a filter in the job monitor, it does not capture jobs which “had an error” in part of their workflow or dataflow but resulted in a successful job.
Can you help me figure out if this can be done?
You can use the ‘Database Table Source’ object by pointing to the repository you are using in Astera Centerprise. Pick table ‘dbo.JobInfo’. This table contains all the information about the currently running jobs. Now point all the fields of this table to a filter and filter it using ‘Status=‘Error’ or RecordsWithErrors>0’ expression. It will filter all the jobs ending in errors, and also jobs with record level errors. Then, you can write this to an Excel destination and also schedule this flow.
Here are some screenshots to explain these steps. Let me know if this works or if you need a sample flow.
