Showing posts with label SQL SERVER 2005 Jobs. Show all posts
Showing posts with label SQL SERVER 2005 Jobs. Show all posts

Thursday, December 24, 2009

Disable and Enable Jobs

set nocount on
set quoted_identifier off
select "exec sp_update_job @job_name = '" + name + "', @enabled = 0 " + "
" + "" from sysjobs where enabled=1 order by 1