Simple question :

How can I find out when a dts job last ran?

sp_help_Job

--
Andrew J. Kelly SQL MVP


"Anthony" <antgoodlife (AT) nospam (DOT) comcast.net> wrote

Andrew,
Thank you for the quick reply...

That works but I just realized I asked the wrong 'question' ... how can
I determine when a dts PACKAGE was last run... (Not all my dts packages are
run from scheduled jobs)...

Does SQL keep any of this information? Thank you in advance.

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

There is no history as such that I know of unless it is scheduled thru sql
agent.

--
Andrew J. Kelly SQL MVP


"Anthony" <antgoodlife (AT) nospam (DOT) comcast.net> wrote

In article <ONigtG$mEHA.3988 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Andrew J. Kelly wrote:
having your DTS package log to SQL Server. This will create a row in
msdb.do.sysdtspckagelog. You can then query this to get the info you
require


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know