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 – T-SQL Script to Check SQL Server Job History
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 – Maintenance Plan Error: Failed to Acquire Connection “Local Server Connection”.
One of my clients had an interesting situation where none of the SQL Maintenance plans were working. The example what I am using here is a SQL Server backup maintenance plan failing. I also saw a behavior where all the individual jobs were working fine as expected.
SQL SERVER – How to Get SQL Server Agent Properties?
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
Question: How to List All the SQL Server Jobs When Agent is Disabled?
How to Schedule a Job in SQL Server? – Interview Question of the Week #160
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 – Express and SQL Server Agent – Free Alternative
“How come my database is only a few MBs big and I am facing performance problems?” My customer asked. I replied, “Well, this is because you are not running job using SQL Server Agent to keep your indexes in the best health.”