开发者

SSIS 2005 - How to figure out what job a sysdtslog90 entry was run under?

开发者 https://www.devze.com 2022-12-31 03:48 出处:网络
Given a entry in a sysdtslog90 table in SQL Server 2005 fro开发者_JAVA技巧m an SSIS package, how do you figure out what database agent job the entry was run under?It looks like, after many tests and e

Given a entry in a sysdtslog90 table in SQL Server 2005 fro开发者_JAVA技巧m an SSIS package, how do you figure out what database agent job the entry was run under?


It looks like, after many tests and examination of the data generated, you should be able to piece out this information for your environment(s) from a mix of the computer, operator, and source columns, and maybe the sourceid if that remains consistant between restarts of SQL Agent. Deriving it by correlating between job run times and the starttime and endtime column is also possible, and even more complex options could be worked through setting the value in the datacode column (however that may be done).

I no longer have anything to do with DTS packages, and so do not have (and cannot generate) any such sample data and provide a better answer. (I'd have made this a comment, but no one else has replied yet, so I'm making it a bit more formal.)

0

精彩评论

暂无评论...
验证码 换一张
取 消