SQL Server - The SQL Agent Job Execution History Is Disappearing May 10, 2023 7 min read Continue reading
SQL Server - How to change the owner of all jobs for a user in SQL Agent October 15, 2018 3 min read Continue reading
SQL Server - How to View the Full Job Execution Return Message Even When It Exceeds 4000 Characters May 2, 2018 3 min read Continue reading
SQL Server - How to search for a string in the code of stored procedures called by SQL Agent jobs September 17, 2017 5 min read Continue reading
SQL Server - Understanding SQL Agent Permissions and Roles: SQLAgentUserRole, SQLAgentReaderRole, SQLAgentOperatorRole February 28, 2017 7 min read Continue reading
SQL Server - How to back up all SQL Agent jobs via command line (CLR C# or PowerShell) February 22, 2017 9 min read Continue reading
How to List Jobs (schedules, commands, steps) via Query in SQL Server March 28, 2016 5 min read Continue reading
How to create an audit to monitor the creation, modification and deletion of Jobs in SQL Server June 5, 2015 4 min read Continue reading
How to convert the run_date and run_time columns from job_history to datetime in SQL Server May 7, 2015 2 min read Continue reading