chuck.forbes (8/7/2015)
And so if I examine every Agent job, and none of them list a step which executes *.dstx file that resembles the "name" column from:select suser_sname(ownersid), t.*
from msdb.dbo.sysssispackages t
Should I assume that there once was a job which referenced the package, and that the packages aren't cleaned up when a job is deleted?
--=Chuck
I would say that is probably a safe assumption.
It could also be possible that the package is called from a different server.
I might pull the package down from the database and verify the package. See what it does and if it even works anymore.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events