To list all jobs with owners, read the job table in msdb and resolve each owner with a join that keeps jobs without a login. This post builds four demo jobs, shows how a common query hides one of them, and reassigns jobs safely. It ends with a cleanup script.
Additional Logging for SQL Server Agent: Three Methods
Additional logging for SQL Server Agent means raising the Agent error log level, so the Agent writes more lines about its own work. This post reads the current level, changes it with T-SQL and restores it in the same script, and shows the Management Studio and registry routes.
Capturing sp_WhoIsActive Snapshots to a Table Every Minute
Capture sp_WhoIsActive snapshots every minute, keep seven days, and query past blockers and long requests from a logging table.
Agent Service Missing in Configuration Manager: The Fix
An Agent service missing in Configuration Manager can come from a wrong program path. This post compares the service lists, reads the Agent path with T-SQL, checks that the file exists, and explains how to repair the path.
SQL SERVER – Event ID 7000 – The System Cannot Find the File Specified
This blog is from one that came from a DBA from one of my consulting engagements. Let us learn how to fix event id 7000 error.
SQL SERVER – Log Shipping Error: Only Members of the Sysadmin Fixed Server Role Can Perform this Operation – 2
Many disaster recovery solutions are available in SQL Server. Let’s learn how we can fix a specific log shipping error about the sysadmin fixed server role.
Application Locks With sp_getapplock: One Job at a Time
Use sp_getapplock to serialize a job, compare transaction and session ownership, handle return codes, and inspect a two-session test.