SQL SERVER – Displaying SQL Agent Jobs Running at a Specific Time

Recently I was troubleshooting at a customer location something that looked trivial. When the customer approached me for a consulting requirement wherein they were saying their system was going unresponsive every day in the morning around a certain time. They were clueless to what is happening and why this was the case almost every day in the week. I got curious to understand what was going wrong with SQL Agent Jobs.

Read More

SQL Server Agent – Unable to start the service – The request failed or the service did not respond in a timely fashion

Rarely, it also happens when someone becomes accidental DBA and may get stumped with simple things. This blog is result of troubleshooting which I have done for a company where I found one such DBA. I don’t say you cannot become a DBA in this manner, it is the hard work that goes behind this that needs to be understood. Let us learn about error related to SQL Server Agent.

Read More

SQL SERVER – Unable to Start SQL Agent – SQL Server Agent Terminated (Normally)

Along with performance issues, I also provide consultancy in other break-fix issues like service not starting etc. These are not run of the mill, but on specific cases only. I always suggest my clients to search on my blog first and then contact me if needed. This is a great way to scale and make people empowered when it comes to solving some of the trivial issues that they might have encountered for SQL Server Agent.

Read More

SQL SERVER – FIX – Agent XPs Component is Turned Off as Part of the Security Configuration for this Server

One of my clients has installed a new instance of SQL Server and then wanted to create maintenance plan. They were complaining about getting some error and we’re looking forward for my help to solve the same. As soon as he did right click on a Maintenance Plan under “Management” node and selected “New Maintenance Plan Wizard” using SQL Server Management Studio as shown below. Let us learn how to fix Agent XPs Component is Turned Off as Part of the Security Configuration for this Server error.

Read More
Exit mobile version