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 |
|
Mikehjun
Starting Member
24 Posts |
 Posted - 2011-01-05 : 18:59:28
|
| Hi,There are tables that are updated 1:30 am. I want to know what make this table get updated at 1:30 am.I looked at the list of jobs and stored procedures but could not find one. Is there way to tell how these tables get updated? I wonder if there are any system tables tell this info?Thanks, |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Mikehjun
Starting Member
24 Posts |
Posted - 2011-01-06 : 11:27:13
|
| Thanks,I found a useful script to run trace on schedule.http://www.mssqltips.com/tipprint.asp?tip=1715 |
 |
|
|
Mikehjun
Starting Member
24 Posts |
Posted - 2011-01-06 : 12:45:48
|
| I ran trace last night and captured activities. There is a SSIS package ran at 1:30 am. Good! but How do I locate this package?In ApplicationName : SSIS-Package1 -{38A6ABCA-4CEG-xxxxxxxxxxx}COBGIS.GISLoginName: city\gis |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Mikehjun
Starting Member
24 Posts |
Posted - 2011-01-07 : 11:31:24
|
| Thank you!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
find jobs or sp that update table