Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raaj
Posting Yak Master
129 Posts |
 Posted - 2010-11-29 : 23:48:54
|
| Hi Guys,When you open the Job Activity Monitor, we can get info about the jobs. The third column is Status (which will be either 'Idle' or 'Executing....')Now,I just want to know which column (and in which table) represents to 'Status' information in the Job Activity Monitor.Thanks,Raaj. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-11-30 : 08:22:18
|
| The information is provided by the system stored procedure sp_help_job:exec msdb..sp_help_job-> http://msdn.microsoft.com/en-us/library/ms186722.aspx- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
|
|
|
Job Activity Monitor