SQL Server Agent Archives - Page 2 of 5 - SQL Authority with Pinal Dave

SQL SERVER – SQL Agent Job and Backslash – Strange Behavior

July 18, 2019

SQL Jobs, SQL Scripts, SQL Server, SQL Server Agent, SQL Stored Procedure

Today’s blog post is about SQL Agent Job and Backslash. I was surprised to see this behavior. Here are the steps to reproduce this behavior.

SQL SERVER – SQL Service Not Getting Started Automatically After Server Reboot While Using gMSA Account

February 27, 2019

Pinal Dave

SQL

SQL Error Messages, SQL Server, SQL Server Agent, SQL Server Security, SQL Server Services

This was the first experiment with gMSA account in my lab and I faced an interesting issue. In my lab environment, I have a complete domain server and member servers. Once I configured gMSA for SQL Server service and restarted the machine, SQL Service didn’t start automatically even though it was set for an automatic startup as shown below.

SQL SERVER – T-SQL Script to Check SQL Server Job History

December 22, 2018

Pinal Dave

SQL Tips and Tricks

SQL DMV, SQL Jobs, SQL Scripts, SQL Server, SQL Server Agent

Yesterday my long time customer from New Zealand asked me during our regular weekly meet of Comprehensive Database Performance Health Check if I know a T-SQL Script to Check SQL Server Job History.

SQL SERVER – SQL Server Agent Missing in SQL Server Management Studio (SSMS)

November 29, 2018

Pinal Dave

SQL

SQL Error Messages, SQL Scripts, SQL Server, SQL Server Agent, SQL Server Management Studio, SSMS

Learning never stops when you are a consultant. While doing my recent Comprehensive Database Performance Health Check my client asked an interesting question. He informed that he is not able to see SQL Server Agent node in SQL Server Management Studio (SSMS). What could be the possible cause? I was able to provide him answers and sharing it here. First, let us understand what he meant. If you look closer at two SSMS connection. Do you notice a difference? Yes. As the title says – SQL Server Agent is missing in the second image. So, what are the possible causes?

SQL SERVER – Unable to Start Service SQLSERVERAGENT on Server (mscorlib)

November 3, 2018

Pinal Dave

SQL

SQL Error Messages, SQL Scripts, SQL Server, SQL Server Agent, Starting SQL

There are several reasons for the error mentioned in the blog title. In this blog, we would learn about one of the causes of error Unable to start service SQLSERVERAGENT on a server.

SQL SERVER – SQL Server Agent Not Starting – Failed to Initialize SQL Agent Log (Reason: Access is Denied).

June 3, 2018

Pinal Dave

SQL

SQL Error Messages, SQL Log, SQL Server, SQL Server Agent, Starting SQL

My lab machine is my playground. Other than my real-world client’s problem, many blogs have come from my lab machine because I keep on breaking something or another on my server. Once I found that I was unable to start SQL Server Agent service for one of the SQL Server instances. In this blog, we would learn how to fix error Failed to initialize SQL Agent log (reason: Access is denied)

SQL SERVER – FIX: Msg 22004 – The Log File is Not Using Unicode Format

May 14, 2018

Pinal Dave

SQL

SQL Error Messages, SQL Log, SQL Scripts, SQL Server, SQL Server Agent, Transaction Log

Recently, I was playing with some settings in SQL Server Agent and encountered an interesting issue. In this blog we would learn about how to fix error Msg 22004 – The log file is not using Unicode format.