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 |
|
kirannatt
Yak Posting Veteran
66 Posts |
 Posted - 2006-08-22 : 18:15:52
|
| Hi All,I want to check how many jobs are running on my production SQL server . Do we have any tool to do that or any other way to check it. Also, I have read only permissions. can I just look at them.Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-22 : 18:28:57
|
| Are you not able to view this information in SQL Server Agent/Jobs in Enterprise Manager?We didn't purchase a copy, but this tool looks great:http://www.idera.com/Products/SQLschedule/We saw a demo of it when Idera came to show us their products. I think you'll need more than just read-only permissions though to get your money's worth.Tara Kizer |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-08-23 : 02:19:58
|
| I belive sp_help_job will do what you need:EXEC msdb.dbo.sp_help_job @execution_status = 0--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
|
|
|
SQL Server Jobs