Difference between revisions of "SQL Agent Insight:Roadmap"

From Brentec Wiki
Jump to navigation Jump to search
Line 8: Line 8:


== Future Considerations ==
== Future Considerations ==
* N210818-1 : Job Monitor : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances.
* <span style="color:#bf0000">'''N210818-1'''</span> : Job Monitor : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances.
* E200602-2 : Job Monitor : new metrics including, ''has steps'', ''no history'', ''success rate < 100%'', ''successful job runs with failed job steps'', ''has alerts'', ''has targets'', ''ms-db backup size'', ''ms-db compressed backup size'', ''number of deleted jobs since last poll''.
* <span style="color:#bf0000">'''E200602-2'''</span> : Job Monitor : new metrics including, ''has steps'', ''no history'', ''success rate < 100%'', ''successful job runs with failed job steps'', ''has alerts'', ''has targets'', ''ms-db backup size'', ''ms-db compressed backup size'', ''number of deleted jobs since last poll''.
** ''number of deleted jobs since last poll'' would additionally log the names of jobs missing.
** ''number of deleted jobs since last poll'' would additionally log the names of jobs missing.
* N210111-1 : Preferences : email authentication via OAuth2.
* <span style="color:#bf0000">'''N210111-1'''</span> : Preferences : email authentication via OAuth2.
* N201014-1 : Job History : Gannt chart similar to Job Conflicts but for Job History.
* <span style="color:#bf0000">'''N201014-1'''</span> : Job History : Gannt chart similar to Job Conflicts but for Job History.
** user would select jobs to chart.
** user would select jobs to chart.
** Gantt chart timeframe based on earliest job history log entry.
** Gantt chart timeframe based on earliest job history log entry.
* N210112-1 : Insight Log : row header icons for long running jobs.
* <span style="color:#bf0000">'''N210112-1'''</span> : Insight Log : row header icons for long running jobs.
* E170517-1 : Job Conflicts : additional context menu items, ''job history''.
* <span style="color:#bf0000">'''E170517-1'''</span> : Job Conflicts : additional context menu items, ''job history''.
* E200612-3 : Job History : access job properties.
* <span style="color:#bf0000">'''E200612-3'''</span> : Job History : access job properties.
* N181004-1 : Database Mail : purging of database mail items and mail log history.
* <span style="color:#bf0000">'''N181004-1'''</span> : Database Mail : purging of database mail items and mail log history.
* N171010-2 : Job Monitor : copy a job(s) between monitored SQL instances.
* <span style="color:#bf0000">'''N171010-2'''</span> : Job Monitor : copy a job(s) between monitored SQL instances.
* N190802-1 : Job Monitor : multi-row selection of jobs to perform actions against selected jobs.
* <span style="color:#bf0000">'''N190802-1'''</span> : Job Monitor : multi-row selection of jobs to perform actions against selected jobs.
* N200827-2 : Preferences : notification quiet hours/days.
* <span style="color:#bf0000">'''N200827-2'''</span> : Preferences : notification quiet hours/days.
* N200822-1 : Insight : open the Job Monitor upon opening the Insight.
* <span style="color:#bf0000">'''N200822-1'''</span> : Insight : open the Job Monitor upon opening the Insight.
* E210103-1 : Insight Log : buttons similar to Log Viewer to filter entries based on severity.
* <span style="color:#bf0000">'''E210103-1'''</span> : Insight Log : buttons similar to Log Viewer to filter entries based on severity.
* N210510-1 : Job Monitor : change owner of a job or multiple jobs.
* <span style="color:#bf0000">'''N210510-1'''</span> : Job Monitor : change owner of a job or multiple jobs.
* N210610-1 : Job Conflicts : a single instance of Job Conflicts that consolidates all jobs from all currently monitored instances.
* <span style="color:#bf0000">'''N210610-1'''</span> : Job Conflicts : a single instance of Job Conflicts that consolidates all jobs from all currently monitored instances.
* N210706-2 : Job Monitor : new column, ''Number of Alerts''.
* <span style="color:#bf0000">'''N210706-2'''</span> : Job Monitor : new column, ''Number of Alerts''.
* N210706-1 : Schedules : new context menu with options, ''Job properties'', ''Job history'', ''Purge job history''.
* <span style="color:#bf0000">'''N210706-1'''</span> : Schedules : new context menu with options, ''Job properties'', ''Job history'', ''Purge job history''.


== Ready for Next Release ==
== Ready for Next Release ==

Revision as of 00:31, 19 October 2021

Interested in knowing what I'm working on or thinking of implementing for the next version of SQL Agent Insight? Read more below.

In Development / Researching

  • N210330-1 : Azure SQL managed instance support
  • E210228-3 : convert entire SQL Agent Insight project to .NET 6
  • N210821-1 : Insight : new job metric showing successful jobs that have failed steps in the history.
  • E210725-1 : Preferences : omit asking to create suspend/resume jobs when opening Job Monitor.
  • N210913-1 : UI : implement column chooser for all data grids with a significant number of columns with ability to save layout.

Future Considerations

  • N210818-1 : Job Monitor : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances.
  • E200602-2 : Job Monitor : new metrics including, has steps, no history, success rate < 100%, successful job runs with failed job steps, has alerts, has targets, ms-db backup size, ms-db compressed backup size, number of deleted jobs since last poll.
    • number of deleted jobs since last poll would additionally log the names of jobs missing.
  • N210111-1 : Preferences : email authentication via OAuth2.
  • N201014-1 : Job History : Gannt chart similar to Job Conflicts but for Job History.
    • user would select jobs to chart.
    • Gantt chart timeframe based on earliest job history log entry.
  • N210112-1 : Insight Log : row header icons for long running jobs.
  • E170517-1 : Job Conflicts : additional context menu items, job history.
  • E200612-3 : Job History : access job properties.
  • N181004-1 : Database Mail : purging of database mail items and mail log history.
  • N171010-2 : Job Monitor : copy a job(s) between monitored SQL instances.
  • N190802-1 : Job Monitor : multi-row selection of jobs to perform actions against selected jobs.
  • N200827-2 : Preferences : notification quiet hours/days.
  • N200822-1 : Insight : open the Job Monitor upon opening the Insight.
  • E210103-1 : Insight Log : buttons similar to Log Viewer to filter entries based on severity.
  • N210510-1 : Job Monitor : change owner of a job or multiple jobs.
  • N210610-1 : Job Conflicts : a single instance of Job Conflicts that consolidates all jobs from all currently monitored instances.
  • N210706-2 : Job Monitor : new column, Number of Alerts.
  • N210706-1 : Schedules : new context menu with options, Job properties, Job history, Purge job history.

Ready for Next Release