post icon

Monitor job activity by using system Views and Stored Procedures

Per monitorare i job in esecuzione su SQL Server 2005 da query è molto semplice, ecco lo snippet:

SELECT program_name, login_time, host_name FROM sys.dm_exec_sessions WHERE status = 'running'
28 marzo 2009 @ 18:20

No comments yet.

Leave a comment

Leave a Reply

Are you human? Time limit is exhausted. Please reload CAPTCHA.