Great scripts.  Very useful. 

Thanks

Vipul

Smart and simple.

I also find using sysjobs_view useful in place of sysjobs. Especially if you are managing more than one server.

The extra colum originating_Server can tell which server the job failed on.

These scripts are very useful.

sql monitoring tips are excelent. i expect more tips like that.

thax and regards

kiran

sql dba

Another tip for xp_readerrorlog -- the first parameter is an integer that determines which error log to read.

xp_readerrorlog      -- current errorlog

xp_readerrorlog 1    -- most recent archived errorlog

xp_readerrorlog 2    -- etc.

Dave.