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 |
|
smilee282000
Starting Member
4 Posts |
 Posted - 2008-07-28 : 12:43:52
|
| I was wondering if anyone knew of a tool that would show a timeline of my sql jobs by day (and by week if possible). I need it to show each job, what time they fire off, and if they are running at the same time, etc. It would be helpful for troubleshooting timing issues and also something I can show to the operations folks on how their jobs are setup. I am hoping to avoid putting one together myself which would be time-consuming & I would have to do it for each server. Thanks! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-28 : 12:54:31
|
| Look at sysjobhistory and sysjobs in MSDB database. |
 |
|
|
smilee282000
Starting Member
4 Posts |
Posted - 2008-07-28 : 13:43:23
|
| I'm actually looking for something visual. I can compile my own data from the MSDB but was looking for something easier to look at. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
smilee282000
Starting Member
4 Posts |
Posted - 2008-07-29 : 11:40:09
|
| Thanks. I installed the trial of Idera but still didn't find what I was looking for. It looks like Spotlight by Quest has something like I want, but it only shows for a few hours. I'll call their customer support to see if I can get what I want.Thanks! |
|
|
|
|
|
|
looking for graphical timeline of sql jobs