Last time a package was executed/called

• Chrissy321

  SSCoach

  Points: 15763

  More actions

  January 17, 2013 at 8:26 am

  #272905

  Hello All,

  This is sort of a variation of the classic "How can a tell the last time a table was accessed?"

  I'm afraid the answer will be similar, you can't.

  How can I tell the last time an SSIS package stored in the msdb database was called? I am trying to find packages no longer in use.

  Thanks

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  January 17, 2013 at 12:07 pm

  #1578431

  Job History is the only thing that comes to mind and that only holds up if all your SSIS packages are called by SQL Agent jobs.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• Chrissy321

  SSCoach

  Points: 15763

  More actions

  January 17, 2013 at 12:15 pm

  #1578434

  Took a look at job history, we use dtexec a lot. I'll have to sleuth this out the old fashioned way....