Question: Where is SQL Jobs Stored?
Answer: In MSDB Database in dbo.sysjobs table. Let us learn about it in today’s blog post.
SQL SERVER – List All Active Background Jobs
During Comprehensive Database Performance Health Check, we had an issue where lots of active background jobs consuming lots of important resources.Â
SQL SERVER – Details About SQL Jobs and Job Schedules
SQL Expert Dominic Wirth has written a very interesting script about SQL Jobs and Job Schedules. Let us learn about that in this blog post.
SQL SERVER – Query to List All Jobs with Owners
During the engagement suddenly a Jr. DBA asked me if I have a query that will list all the jobs in their system with the Job’s owner.
SQL SERVER – SQL Agent Job and Backslash – Strange Behavior
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.