|
|
| (89 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| Interested in knowing what I'm working on or thinking of implementing for the next version of SQL Agent Insight? Read more below. | | Interested in knowing what I'm working on or thinking of implementing for the next version of SQL Agent Insights? Read more below. |
| | |
| == In Development / Researching == | | == In Development / Researching == |
| * <span style="color:#bf0000">'''N210330-1'''</span> : Azure SQL managed instance support
| | <br/> |
| * <span style="color:#bf0000">'''E210228-3'''</span> : convert entire SQL Agent Insight project to .NET 6
| | <span style="color:red"><b>UPDATE:</b></span> Please see this [https://brentec.ca/blog/2024/09/the-future-of-sql-agent-insights/ blog post] regarding the future of SQL Agent Insights. Thank you. |
| * <span style="color:#bf0000">'''N210821-1'''</span> : Insight : new job metric showing successful jobs that have failed steps in the history.
| |
| * <span style="color:#bf0000">'''E210725-1'''</span> : Preferences : omit asking to create suspend/resume jobs when opening Job Monitor.
| |
| * <span style="color:#bf0000">'''N210913-1'''</span> : UI : implement column chooser for all data grids with a significant number of columns with ability to save layout.
| |
| | |
| == Future Considerations ==
| |
| * <span style="color:#bf0000">'''N210818-1'''</span> : Job Monitor : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances.
| |
| * <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.
| |
| * <span style="color:#bf0000">'''N210111-1'''</span> : Preferences : email authentication via OAuth2.
| |
| * <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.
| |
| ** Gantt chart timeframe based on earliest job history log entry.
| |
| * <span style="color:#bf0000">'''N210112-1'''</span> : Insight Log : row header icons for long running jobs.
| |
| * <span style="color:#bf0000">'''E170517-1'''</span> : Job Conflicts : additional context menu items, ''job history''.
| |
| * <span style="color:#bf0000">'''E200612-3'''</span> : Job History : access job properties.
| |
| * <span style="color:#bf0000">'''N181004-1'''</span> : Database Mail : purging of database mail items and mail log history.
| |
| * <span style="color:#bf0000">'''N171010-2'''</span> : Job Monitor : copy a job(s) between monitored SQL instances.
| |
| * <span style="color:#bf0000">'''N190802-1'''</span> : Job Monitor : multi-row selection of jobs to perform actions against selected jobs.
| |
| * <span style="color:#bf0000">'''N200827-2'''</span> : Preferences : notification quiet hours/days.
| |
| * <span style="color:#bf0000">'''N200822-1'''</span> : Insight : open the Job Monitor upon opening the Insight.
| |
| * <span style="color:#bf0000">'''E210103-1'''</span> : Insight Log : buttons similar to Log Viewer to filter entries based on severity.
| |
| * <span style="color:#bf0000">'''N210510-1'''</span> : Job Monitor : change owner of a job or multiple jobs.
| |
| * <span style="color:#bf0000">'''N210610-1'''</span> : Job Conflicts : a single instance of Job Conflicts that consolidates all jobs from all currently monitored instances.
| |
| * <span style="color:#bf0000">'''N210706-2'''</span> : Job Monitor : new column, ''Number of Alerts''.
| |
| * <span style="color:#bf0000">'''N210706-1'''</span> : Schedules : new context menu with options, ''Job properties'', ''Job history'', ''Purge job history''.
| |
|
| |
|
| == Ready for Next Release ==
| | * Azure® SQL managed instance support. |
| | * Convert entire SQL Agent Insights project to .NET 6 or greater. |
| | * Different licensing models. |
| | * Copy agent jobs between monitored instances. |
| | * Job conflicts per individual job. |
| | * Dynamic metric thresholds. |
| | * Proxy creation, deletion and modification. |
| | * Ability to sync settings between Insights. |
| | * Calendar control to supplement Job Outlook. |
| | * Ability to overlay multiple instances within Job Outlook. |
| | <br/> |
| | {{BrentecFooter}} |
| | {{MicrosoftFooter}} |