We need to be able to report on Automation Services job failures as this functionality is not present in Automation Services (ie: job failure notification via e-mail when failure occurs).
1.) The JOB_INSTANCES table is purging rows after approximately 48 hours. We need to be able to control purge length of time.
2.) The Automation Services logging tables (JOB_INSTANCES, JOB_SCHEDULES, JOB_TASKS, and JOBS_LATEST) are logging times that are 5 hours ahead of local and server time. This needs to be configurable.
3.) We need a joining key for tables JOB_SCHEDULES and JOB_INSTANCES.