Nov 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – Fix – Agent Starting Error 15281 – SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent XPs’ because this component is turned off as part of the security configuration for this server

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server Agent
SQL Server Agent fails to start because of the error 15281 is a very common error. When you start to restart SQL Agent sometimes it will give following error. SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent XPs’ because this component is turned off as part of the…
Read More

SQL SERVER – Find Next Running Time of Scheduled Job Using T-SQL

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Agent

I often receive a good question on the blog, however, I do not always receive a good answer for the questions. Recently someone asked on a blog about Finding next run time for Schedule Job using T-SQL. My friend came up with a nice script. I have modified it a bit to adjust needs. This blog post is about finding the next running time of scheduled job using T-SQL. 

Read More

SQL SERVER – What is New in SQL Server Agent for Microsoft SQL Server 2005

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Download, SQL Error Messages, SQL Server Agent, SQL Utility
I came across this interesting and detailed article ‘What’s New in SQL Server Agent for Microsoft SQL Server 2005‘ on Microsoft TechNet. This article describes Security Improvements, New Roles in the msdb Database, Multiple Proxy Accounts, Performance Improvements, Performance Counters, New SQL Server Agent Subsystems, Shared Schedules, WMI Event Alerts,…
Read More