— List processes currently running through SQLServer Agent select spid, program_name, blocked from master..sysprocesses where program_name like ‘SQLAgent%’ spid program_name… READ MORE
|
http://blog.flimatech.com/?p=1291 READ MORE
|
Using the SELECT statement below one can list notications that occur for jobs scheduled on SQLServer. SELECT –Job name sj.name… READ MORE
Information on sysjobhistory Information on sysjobs — shows job history with the most recent one to show the most recent… READ MORE
“Control what I can control”
~ Alex Lima