dbareports icon indicating copy to clipboard operation
dbareports copied to clipboard

AgentJobSummary only gets updated once a day, do we want to make it more universal

Open SQLDBAWithABeard opened this issue 9 years ago • 2 comments

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?

SQLDBAWithABeard avatar Aug 24 '16 12:08 SQLDBAWithABeard

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

SQLDBAWithABeard avatar Aug 24 '16 12:08 SQLDBAWithABeard

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.

jstexasdba avatar Aug 24 '16 17:08 jstexasdba