Difference between revisions of "SQL Agent Insight:Roadmap"

From Brentec Wiki
Jump to navigation Jump to search
Line 17: Line 17:
== Future Considerations ==
== Future Considerations ==
{| role="presentation" class="wikitable mw-collapsible mw-collapsed"
{| role="presentation" class="wikitable mw-collapsible mw-collapsed"
| <strong><span style="color:green">New</span></strong>
| <strong><span style="color:#1FB141">New</span></strong>
| Job Monitor : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances.
| Job Monitor : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances.

Revision as of 11:22, 2 January 2022

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


  • Azure SQL managed instance support
  • UI : implement column chooser for all data grids with a significant number of columns with ability to save layout.
  • Insight : Show / log jobs that have a successful outcome but have failed steps within them.
  • Operators : the ability to create, modify, delete, script, rename, and copy operators. Ability to directly specify failsafe operator.

Enhancement / Improvement

  • Convert entire SQL Agent Insight project to .NET 6
  • Preferences : omit asking to create suspend/resume jobs when opening Job Monitor.
  • UI : update legacy taskbar notification icons.


Future Considerations

Ready for Next Release

Released with version 0.23.2111.0

  • E211021-1 : Job Conflict Outlook : refactor to Job Conflicts.
  • E200919-4 : About dialog license indicator; showing the number of days before expiry; if expiry date is approaching, tab icon is now present and number of days highlighted to bring focus.
  • E211026-2 : verbiage for Suspend Job tooltip in Job Monitor is incorrect. Cannot extend job suspension from the context menu, therefore revised.
  • E211026-1 : change verbiage in the suspend/resume create job dialog of Agent Job Monitor to Job Monitor.
  • E211001-3 : Insight tabs context menu foreground color from white to black, easier to read.
  • E211028-3 : Due to improved performance in release 0.23.2109.50, help verbiage in Job Conflicts and its pop-up help dialog changed to suit.
  • B211005-1 : Exceptions can be thrown when/if the preferences xml, SQLAI_Preferences.XML, has been modified/deleted outside of SQL Agent Insight. Default preferences are assigned prior to loading to mitigate this issue. The preferences file should only be modified by SQL Agent Insight, however, we cannot prevent a user from doing so.
  • E210718-1 : Remove CR and LF characters from description and body column data to prevent cell text wrapping. Database Mail Items; Database Mail Event Log
  • B211110-1 : System.NullReferenceException: 'Object reference not set to an instance of an object.' may occur after closing an Insight. Resolved.
  • B211110-2 : Dashboard : Alarms category column no longer showing metric name. Affected versions 0.23.2109.0, 0.23.2109.50
  • N210821-1 : Insight : Two (2) new job metrics. One, successful job outcomes with failed job steps from the entire job history. Two, successful job outcomes with failed job steps in the past 3 days. This brings the total number of monitored metrics to 65.
  • B211116-1 : Insight : Insight log collection finish time is the same as the collection start time.
  • B211116-2 : Insight : Threshold validation may sometimes result in an incorrect severity being applied to a metric, and potentially not issuing notifications.