SQL 2005 Blocking Issues

sp_who2 active
sp_blocked
dbcc inputbuffer(74)

Coping SSIS Jobs to different Server

SELECT 'dtutil /COPY SQL;' + NAME + ' /SourceS servera /SQL ' + NAME + ' /DestS serverb
FROM msdb.dbo.sysdtspackages90

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