SQL Job Commander 0.2: See Your SQL Agent Jobs in a New Light Anyone who manages SQL Server® Agent across several instances knows the routine. SSMS gives you one Job Activity Monitor window per instance, and the features you need are buried under menus. SQL Job Commander was built to fix that, and version 0.2 …
Well, the time is coming unfortunately, but it would appear that I’m going to have to embrace Windows 11. I’m none too pleased with the taskbar and the fact that you cannot move it to the left of the screen, something that I’ve had in place in all previous Windows iterations (since ’95), which makes …
Hi Everyone. Here we are well into 2024 and it has been a busy year or so since my last update. After our family move last year, we’ve been busy with renovations on the cottage here on the premises, with plans eventually to rent it, but that project has been slow going and it’s not …
The title pretty much nails it. This new undertaking, SQL Job Commander, will be very much in line with my my current offering, SQL Agent Insights, but less ambitious, at least initially 😉 Just wanted to blog this for visibility and search purpose reasons. Definitely more to come in the future. Cheers.
This release of SQL Agent Insights focused on proxies, namely creating, deleting and modifying them. Previous versions just showed the data, but with this release, all of your proxy requirements are met directly within SQL Agent Insights. As with every release, enjoy, and if you have any comments/questions, feel free to reach out here. Below …
This has been mostly a bug fix release while extending the license out to April of 2024. The biggest thing you will notice (perhaps you won’t) is the re-branding of the product to SQL Agent Insights from SQL Agent Insight. I thought this was more apt for the name since there are multiple insights into …
Hi Everyone. It’s been some time since I’ve written a blog post, and I haven’t released a newer version of SQL Agent Insight since February; the life outside of my day job (Senior Data Architect) and my hobbies has been a busy one for the family and myself. The past six months can be summarized …
The last six months and the future of SQL Agent Insight Read More »
This release is a special one for me since the newest feature, allowing one to create/edit agent jobs, was long on my list to accomplish and now appears in this build. It took me some time to develop this feature since there were not very many C# examples of how to use SMO to create …
Problem: One or more of your operators are not getting notifications from SQL Server agent alerts or jobs. Solution: This could be for a number of reasons, but more than likely it is because an operator or alert is disabled, or both. Let’s use the query below and determine what is causing the underlying problem …
T-SQL script showing why SQL Server operators may not receive notifications Read More »
Problem: Sometimes SQL Server agent jobs do not work as expected due to either syntax or logical errors. In this blog post, I attempt to show you how to identify SQL Server agent jobs that do not provide the desired outcome as a result of logic errors, that is, jobs in which some steps ‘on …
Identify SQL Server agent jobs that do not run all steps Read More »
