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

SQL SERVER – How to Get SQL Server Agent Properties?

May 1, 2018

SQL Jobs, SQL Scripts, SQL Server, SQL Server Agent, SQL Server Management Studio

During Comprehensive Database Performance Health Check we always go over various SQL Server properties. Lots of people do not know that there are quite a few SQL Server settings which can help us improve our SQL Server performance many folds. While I was discussing SQL Server properties, someone asked me if there are similar settings for SQL Server Agent available which users can tune.

How to List All the SQL Server Jobs When Agent is Disabled? – Interview Question of the Week #171

April 29, 2018

Pinal Dave

SQL Interview Questions and Answers

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

Question: How to List All the SQL Server Jobs When Agent is Disabled?

SQL SERVER – Unable to Start SQL Server Agent. Error – Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed

February 23, 2018

Pinal Dave

SQL

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

If someone tells me any situation, the first question which I always ask is “What is the error message?”. Now to get the right error message, it is important to look at the right log file. In this blog, we would learn about SQL Server Agent startup issue.

SQL SERVER – Unable to Start Jobs – Error: Enumerate Target Servers Failed for Job

February 22, 2018

Pinal Dave

SQL

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

They showed me below error when they were trying to run a job. Let us see how we can fix the error Enumerate Target Servers Failed for Job.

SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘sqlagent100_msdb_upgrade.sql’ – Error: 5041: MODIFY FILE Failed

February 13, 2018

Pinal Dave

SQL

SQL Error Messages, SQL Log, SQL Server, SQL Server Agent, SQL Upgrade, Starting SQL, System Database

I have helped many clients in upgrade failures via my On-Demand consulting and I am amazed to see various ways which can break SQL Server upgrade. In this blog we would learn about fixing error Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’

How to Schedule a Job in SQL Server? – Interview Question of the Week #160

February 11, 2018

Pinal Dave

SQL Interview Questions and Answers

SQL Jobs, SQL Server, SQL Server Agent, SQL Utility

Question: How to Schedule a Job on SQL Server?

Answer: A very old and widespread question, keep on coming back to in interviews. Let us see how to schedule a job on SQL Server.

SQL SERVER – Log Shipping Monitor Not Getting Updated

January 6, 2018

Pinal Dave

SQL

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

One of my clients has implemented log shipping and everything was working fine. Recently they implemented a reporting tool which reported alerts that data missing for few log shipping tables. The data for “last_backup_file” and “last_backup_date” is not getting updated for primary server (log_shipping_monitor_primary) and was showing null. For secondary it was reported correctly.