admin subsystem tasks

This is an excerpt from the output of script_tasks on msdb on my admin SQL Server. (The full script actually contains 17 dbSync tasks, 4 logSync tasks, 30 maintenance tasks, 10 reindex tasks, and 14 update statistics tasks.)

You can add any task to your SQL Server by executing the sp_addtask in isql/w. This will let you see what the task looks like from the 'Manage Scheduled Tasks' dialog of Enterprise Manager.


 msdb..sp_addtask 'Block Monitor',TSQL,@@SERVERNAME,sa,admin,1,4,1,2,10,0,0,199
	80101,19991231,60000,220000,19980514,92410,0,'SQL_DBA',0,0,
        'check_for_blocks',0,2,'Check for Blocked Searchers'                               
	                                    	                                    	                                    
 msdb..sp_addtask 'dbSync ucc LIEN to HS_LEIN',TSQL,@@SERVERNAME,sa,admin,1,8,7
	2,1,0,1,1,19971021,99991231,170000,235959,0,0,0,'SQL_DBA',0,0,
        'dbSync ucc, filings, lien, @target = hs_lein',0,2,''                           
	                                    
 msdb..sp_addtask 'dbSync ucc w/out maintenance LIEN to HS_LEIN',TSQL,@@SERVERNAME,
        sa,admin,0,2,0,1,0,1,1,19971119,99991231,170000,235959,0,0,0,'SQL_DBA',0,0,
        'dbsync ucc, filings, lien, @target = hs_lein, @maintain = false',0,2,''
                           
 msdb..sp_addtask 'dbSync users HS_LEIN to LIEN',TSQL,@@SERVERNAME,sa,admin,0,2
	,0,1,0,1,1,19980422,99991231,0,235959,0,0,0,'SQL_DBA',0,0,
        'dbsync users ,action, hs_lein, @target = lien, @maintain = false',0,2,''           
	                                    
 msdb..sp_addtask 'dbSync users LIEN to HS_LEIN',TSQL,@@SERVERNAME,sa,admin,1,4  
        ,1,1,1,1,1,19971020,99991231,50000,235959,19980515,50000,0,'SQL_DBA',0,
	0,'dbSync users, action, lien, @target = hs_lein',0,2,''               
	                                    
 msdb..sp_addtask 'Fix Identities - All Databases',TSQL,@@SERVERNAME,sa,admin,0
	,2,0,1,0,1,1,19980113,99991231,0,235959,0,0,0,'SQL_DBA',0,0,
        'check_ident',0,2,''                                                              
	                                    
 msdb..sp_addtask 'Fix Identities <Add db Name>',TSQL,@@SERVERNAME,sa,admin,0,2
	,0,1,0,1,1,19980113,99991231,0,235959,0,0,0,'SQL_DBA',0,0,
        'check_ident bwtest',0,2,''                                                         
	                                    
 msdb..sp_addtask 'logSync bwtest LIEN to HS_LEIN',CmdExec,@@SERVERNAME,sa,,0,2
	,0,4,5,1,1,19971218,99991231,0,235959,0,0,0,'SQL_DBA',0,0,
        'isql -Shs_lein -Usa -P -dadmin -Q"logSync bwtest, action, lien, hs_lein, @debug=true" -oe:\restore\bwtest\logSync.dbg' 
	                                    
 msdb..sp_addtask 'logSync ucc LIEN to HS_LEIN',TSQL,@@SERVERNAME,sa,admin,1,8,
	126,8,2,1,1,19980212,99991231,81000,161059,0,0,0,'SQL_DBA',0,5,
        'logSync ucc, filings, lien, hs_lein',0,2,''                                   
	                                    
 msdb..sp_addtask 'logSync users LIEN to HS_LEIN',TSQL,@@SERVERNAME,sa,admin,1,
        4,1,4,10,1,1,19980406,99991231,60000,215959,19980514,93000,0,'SQL_DBA',
	0,0,'logSync users,action,lien, hs_lein',0,2,''                        
	                                    	                                    
 msdb..sp_addtask 'Maintain dmv.master',TSQL,@@SERVERNAME,sa,admin,1,8,126,1,0,
        1,1,19980505,99991231,214500,235959,19980514,214500,0,'SQL_DBA',0,0,
        'maintenance master, DMV, " ", alld',0,2,''                               
	                                    
 msdb..sp_addtask 'Maintain dmv.msdb',TSQL,@@SERVERNAME,sa,admin,1,8,34,1,0,1,1
	,19980505,99991231,213000,235959,19980515,213000,0,'SQL_DBA',0,0,
        'maintenance msdb,DMV, " ",alld',0,2,''                                      
	                                    
 msdb..sp_addtask 'Maintain hs_lein.master',TSQL,@@SERVERNAME,sa,admin,1,8,124,
        1,0,1,1,19971028,99991231,211500,235959,19980514,211500,0,'SQL_DBA',0,0
	,'maintenance master,hs_lein,"",alle,backup,true',0,2,''               
	                                    
 msdb..sp_addtask 'Maintain hs_lein.model',TSQL,@@SERVERNAME,sa,admin,0,2,0,1,0
	,1,1,19980506,99991231,0,235959,0,0,0,'SQL_DBA',0,0,
        'maintenance model,hs_lein,"",alle,backup,true',0,2,''                                    
	                                    
 msdb..sp_addtask 'Maintain hs_lein.msdb',TSQL,@@SERVERNAME,sa,admin,1,8,124,1,
        0,1,1,19971119,99991231,210000,235959,19980514,210000,0,'SQL_DBA',0,0,
        'maintenance msdb,hs_lein,"",alle,backup,true',0,2,''                   
	                                    
 msdb..sp_addtask 'Maintain lien.master',TSQL,@@SERVERNAME,sa,admin,1,8,124,1,0
        ,1,1,19980508,99991231,224500,235959,19980514,224500,0,'SQL_DBA',0,0,
        'maintenance master, lien',0,2,''                                        
	                                    
 msdb..sp_addtask 'Maintain lien.msdb',TSQL,@@SERVERNAME,sa,admin,1,8,42,1,0,1,
	1,19980508,99991231,223000,235959,19980515,223000,0,'SQL_DBA',0,0,
        'maintenance msdb, lien',0,2,''                                             
	                                    
 msdb..sp_addtask 'Quick Switch users to Hot Site (no logSync)',TSQL,
        @@SERVERNAME,sa,admin,0,2,0,1,0,1,1,19971223,99991231,0,235959,0,0,0,
        'SQL_DBA',0,0,'setUsersToHotSite',0,2,''                                           
	                                    	                                    
 msdb..sp_addtask 'Reindex lien.ucc',TSQL,@@SERVERNAME,sa,admin,1,8,4,1,0,1,1,1
	9980504,99991231,20000,235959,19980519,20000,0,'SQL_DBA',0,0,
        'run_script_remote reindex, ucc, lien, " ", "\\lien\alle\backup\ucc", @ext = "all"'
        ,0,2,''                           

 msdb..sp_addtask 'Reindex lien.users',TSQL,@@SERVERNAME,sa,admin,1,8,1,1,0,1,1
	,19980501,99991231,23000,235959,19980517,23000,0,'SQL_DBA',0,0,
        'run_script_remote reindex, users, lien, " ", "\\lien\alle\backup\users", @ext = "all"'
        ,0,2,''                     

 msdb..sp_addtask 'Set HS_LEIN System Time to COMM's time',TSQL,@@SERVERNAME,sa
        ,admin,1,4,1,1,0,1,1,19980406,99991231,120000,235959,19980514,120000,0,
	'SQL_DBA',0,0,'dispatch 'net time \\comm /set /yes','set_time'',0,2,'' 
	                                    
 msdb..sp_addtask 'Set hs_lein.admin to trunc. log on chkpt',TSQL,@@SERVERNAME,
	sa,master,1,4,1,8,4,1,1,19980514,99991231,0,235959,0,0,0,'',0,0,
        'EXEC sp_dboption uccRes,"trunc. log on chkpt.",true',2,0,''                  
	                                    
 msdb..sp_addtask 'Switch users to Hot Site w/logSync',TSQL,@@SERVERNAME,sa,
        admin,0,2,0,1,0,1,1,19971223,99991231,0,235959,0,0,0,'SQL_DBA',0,0,
        'logSyncThenSetUsersToHotSite',0,2,''                                         
	                                    
 msdb..sp_addtask 'Update Statistics lien.ucc',TSQL,@@SERVERNAME,sa,admin,1,8,1
        23,1,0,1,1,19980503,99991231,20000,235959,19980515,20000,0,'SQL_DBA',0,0,
        'run_script_remote update_statistics, ucc,lien, " ", "\\lien\alle\backup\ucc", @ext = "all"',0,2,''      

 msdb..sp_addtask 'Update Statistics lien.users',TSQL,@@SERVERNAME,sa,admin,1,8
        ,126,1,0,1,1,19980504,99991231,23000,235959,19980515,23000,0,'SQL_DBA',0,0,
        'run_script_remote update_statistics, users,lien, " ", "\\lien\alle\backup\users", @ext = "all"',0,2,'