September 25, 2007 at 7:31 am
I am looking for a system table that has information per DTS package like what is stored for Jobs in the msdb.dbo.jobs table. Anyone ?
September 25, 2007 at 8:07 am
What information are you looking for? I'm not sure what you mean like what is in jobs".
September 25, 2007 at 9:21 am
What I am looking for is a way to tie the DTS package to it's related JOB. If I was to do a SELECT * FROM msdb.dbo.sysjobs I get a lot of information about the JOBS. If I do a SELECT * FROM msdb.dbo.sysdtspackages I get a lot of info about the DTS Package. But, so far, the only tie between the two is if I turn Logging on within the DTS package . . . but, I still cannot tie DTS to JOBS once scheduled. There is a rare Description and the use of Script To SQL to find, but, many times the DTS package looses the description and picks up something else and the GUID is sent to the JOBS. I am looking to tie the DTS to the JOBs running to perform a one to one or one to many to maintain what is there and what does not need to be there etc.
October 2, 2007 at 9:16 am
The only link between jobs and packages that I can think of would be in sysjobsteps where the DTSRUN command is stored in the command column.
Greg
Greg
June 10, 2010 at 9:26 am
You will only be able to see name of the package in the dtsrun commands, for job steps if they were created unencrypted.
If you see something like DTSRun /~Z0xAEB6B4553DB09E5771B56FD6C06B30B37....... Then the job was created referencing a specific version of the package and the command is encrypted. What you are looking for is something like: DTSRUN /SServerName /E /NPackageName
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply