Home Forums SQL Server 2005 Administering How do i get 'Last Execute' time NOT 'Last Run time' RE: How do i get 'Last Execute' time NOT 'Last Run time'

  • Misread, you wanted the time.

    Look in [msdb].[dbo].[jobactivity]. It looks like you want [stop_execution_date].

    ----------------------------------------------------------------------------
    Sacramento SQL Server users group - http://sac.sqlpass.org
    Follow me on Twitter - @SQLDCH
    ----------------------------------------------------------------------------

    Yeah, well...The Dude abides.