December 30, 2002 at 2:34 pm
This may be a dumb question but...I have 14 DTS packages written by other people, all of whom are no longer employed here. Can I assumme that if there is no scheduled job for these packages that they were a one time package?
I also have have 4 jobs under sql server agent that run DTSRun - how can i tell which package corresponds to which job. I tried to compare the hex # in the DTSRun line to see if I can compare this # to a package ID number but that didnt work!
My head is starting to spin!!!
Thanks in advance and Happy Holidays to all!
December 30, 2002 at 2:56 pm
kjackson in the msdb database you can find all information for a pkg.
Inside the pkg right click under properties also you can see some information Pkg GUID and version.
JFB
December 30, 2002 at 6:17 pm
Just because no job doesn't mean not being used. Could be they are executed manually as needed, or that someone is connecting using VB to run it (and maybe make changes to it before running). To find out you can Profile for a while - I think sp_start_package (spelling?). You could also rename the package for a while, though if they are using the GUID for the package it won't catch those, but no reason you can't alter that as well. That way if you're wrong you can just flip it back.
You could also script out as VB but you will lose text annotations if you need to script it back in. Not sure if that happens if you save out as a COM structured file or not. Finally, you can always just delete and hold the backup for a while in case you need it!
Andy
December 31, 2002 at 4:35 am
Open each questionable package and then the package properties. Turn on logging in the package properties (varies depending on you version but look at all the tabs it is quite easy to find) and save the package. Give a month or two and see if the long shows any activity. If not the I suggest opening the package and save as DTS file to hard drive and store that somewhere then deleet the package from the server. If someone shows up later saying they ran it once a year or quarter you still have the package you can recall you saved to disk.
December 31, 2002 at 8:23 am
As always - thank you one and all for your suggestions.
It is a nice feeling, when I am stumped, that I have somewhere to go to get great suggestions.
Thank you and Happy New Year!!
Karen
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply