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 |
|
tbrothers
Yak Posting Veteran
83 Posts |
 Posted - 2010-09-15 : 16:18:44
|
| Hello,We have a database whose log file will grow out of control overnight. I am running a trace in SQL Profiler and am monitoring "Database => Log File Auto Grow".The trace logged an event where the Application Name is"SQLAgent - TSQL JobStep (Job 0x5F56C1AA57107444A420BC9B70DE7F29 : Step 3)"How can I correlate 5F56C1AA57107444A420BC9B70DE7F29 to a SQL job?I have looked in the msdb tables sysjobs and sysjobsteps but did not find a match.Thank you!Terry |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tbrothers
Yak Posting Veteran
83 Posts |
Posted - 2010-09-15 : 16:30:01
|
| Thanks for the quick reply Tara!That wasn't it. We rebuild indexes only once a week on Sundays.Thanks,Terry |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tbrothers
Yak Posting Veteran
83 Posts |
Posted - 2010-09-15 : 16:33:31
|
| There are only two maintenance plans ... backup databases that run every night at 9:00 pm and the optimizations that run Sundays at 3:00 am.Thanks,Terry |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
SQL Profiler - Application Name