Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: How to get output of SP_HELP_JOB into a script?

    Tested on SQL Server 2005 and 2012. This script select jobs that are currently running.

    declare @CurrentJobs table

    (

    [Job ID] uniqueidentifier,

    [Last Run Date] varchar(255),

    [Last Run Time] varchar(255),

    [Next Run Date] varchar(255),

    [Next Run...

    January 30, 2014 at 1:53 pm

    #1684846

Viewing post 1 (of 1 total)