Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2005 » SQL Server Agent   (RSS)
Script out Jobs in SQL Server
Do you want to script out the jobs available in SQL Server Agent ? There a many ways to skin the cat. The probably easiest one is to us the built in functionality of SSMS. Simply select all the jobs (doing a STRG+A on the Object Explorer list) and choose Read More...
Determine the current status of a SQL Server Agent job
Due to the problem that there is no definite table for getting information about the current status of jobs, I created a small procedure grabbing the information from parts of the internal procedures used to extract the very relevant information. As an Read More...
Page view tracker