package last run date

[Andre]

SQL2k sp4

Is it possible to determine when a DTS package was last run? We have a lot
of packages, and we're sure some are no longer needed. But we don't know
for sure so we're hoping there is a way to determine when they were last
run.

Thanks, Andre

[tbradshaw via SQLMonster.com]

Hello Andre,

Are these packages run by a SQL Agent job, or some other scheduling means?
Perhaps you can examine the history of those jobs. The Application/Event Log
might contain information too.

The sure-fire way I use is to use package logging. That way I can examine
the run-times of any package. To do this:

Right-click in designer window not on any icon
Properties
Logging tab
I use 'Error Handling' and point to a file
Note checkbox 'Write completion status to event log'

If you point all your packages to separate log files, you can examine
separate modification dates and get a good idea when packages run.

Let us know how things make out.

Regards,
Tom

Thomas Bradshaw
Data Integration Services
MyWebGrocer LLC

Post by Andre
SQL2k sp4
Is it possible to determine when a DTS package was last run? We have a lot
of packages, and we're sure some are no longer needed. But we don't know
for sure so we're hoping there is a way to determine when they were last
run.
Thanks, Andre

[Andre]

Thanks for the reply. The jobs have been run manually, so without logging
I'm thinking that I have no way of currently knowing when one has been run.
Please correct me if I'm wrong.

Andre

[tbradshaw via SQLMonster.com]

Hello Andre,

You are correct. For manually run DTS packages, there is no way of knowing
unless you either:

- Purposely log to a file (that Error File Pathname)
- Write to Application Event Log (that check box)

Either way requires a visit/mod to each package.

Best Regards,
Tom

Thomas Bradshaw
Data Integration Services
MyWebGrocer LLC

[hfdev]

I run my "child packages" from a "master package" and have the master update
a table with the "Last Run Date & Time" so I know which chile packages
completed and which ones didn't run.

You could make each child package update a table with it's last run time too.

HTH
--
Josh Blair (hfdev)
HydraForce, Inc.

Post by Andre
SQL2k sp4
Is it possible to determine when a DTS package was last run? We have a lot
of packages, and we're sure some are no longer needed. But we don't know
for sure so we're hoping there is a way to determine when they were last
run.
Thanks, Andre

[Andre]

Got it. Thanks to both of you for responding.

Andre