Home Forums SQL Server 7,2000 T-SQL How to get output of SP_HELP_JOB into a script? RE: How to get output of SP_HELP_JOB into a script?

  • February 16, 2006 at 9:18 pm

    #621539

    Not sure it will work, but why not try?

    SET @SQL = insert into #TempJobTable

      EXEC('execute sp_help_job @category_name=N''REPL-Merge'', @enabled=1, @execution_status=4')

     

    _____________
    Code for TallyGenerator