Re: dts job last ran

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 09/16/04 

Date: Thu, 16 Sep 2004 09:32:51 -0400

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

-- 
Andrew J. Kelly  SQL MVP
"Anthony" <antgoodlife@nospam.comcast.net> wrote in message
news:O1gq$k5mEHA.1296@TK2MSFTNGP09.phx.gbl...
> 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@shadhawk.com> wrote in message
> news:O9eGnN5mEHA.3876@TK2MSFTNGP15.phx.gbl...
> > sp_help_Job
> >
> > -- 
> > Andrew J. Kelly  SQL MVP
> >
> >
> > "Anthony" <antgoodlife@nospam.comcast.net> wrote in message
> > news:%239Etj44mEHA.3564@tk2msftngp13.phx.gbl...
> > > Simple question :
> > >
> > > How can I find out when a dts job last ran?
> > >
> > >
> >
> >
>
>

Relevant Pages