AgentJobSummary only gets updated once a day, do we want to make it more universal
AgentJobSummary only gets updated once a day, do we want to make it more universal to handle situations where people might recycle logs after maybe 1000 total messages? Agent Job Details captures the records if you set up the job to run every 30 minutes or so or do we want to populate the report using details?
This I think is a no
The server roll up of the agent jobs is useful for a quick early morning view for a DBA and a rolling how are we doing overview
However, I think that this functionality could be replicated by running the AgentJobDetail job more frequently and using that to provide an up to date (separate ?) report
This was always a thought that I had in mind to be able to have an update of ho we are doing through the day
Going to write a report and add 2 additional parameters for time or do you think different params? StartTime and EndTime is what I was thinking.