SELECT  Server,
        name,
        CASE WHEN [freq_subday_type] = 0 THEN 'Job Not Scheduled'
             WHEN [freq_subday_type] = 1
             THEN 'Job Runs at  '
                  + CASE WHEN LEN(Active_Start_Time) = 5
                         THEN CAST('0' + LEFT(Active_Start_Time, 1) + ':'
                              + Substring(CAST(Active_start_time AS varchar(6)),
                                          1, 2) + ':'
                              + Substring(CAST(Active_start_time AS varchar(6)),
                                          3, 2) AS varchar(8))
                         ELSE CAST(LEFT(Active_Start_Time, 2) + ':'
                              + Substring(CAST(Active_start_time AS varchar(6)),
                                          2, 2) + ':'
                              + Substring(CAST(Active_start_time AS varchar(6)),
                                          4, 2) AS varchar(8))
                    END
             WHEN [freq_subday_type] = 2
             THEN 'Job Run Every ' + CAST(Freq_subday_interval AS VARCHAR(6))
                  + ' Seconds'
             WHEN [freq_subday_type] = 4
             THEN 'Job Runs Every ' + CAST(Freq_subday_interval AS VARCHAR(6))
                  + ' Minutes'
             WHEN [freq_subday_type] = 8
             THEN 'Job Runs Every ' + CAST(Freq_subday_interval AS VARCHAR(6))
                  + ' Hours'
             ELSE 'Unknown'
        END AS Freq_Interval_Dscr,
        Job_Enabled,
        CAST(CASE WHEN LEN(Active_Start_Time) = 5
                  THEN CAST('0' + LEFT(Active_Start_Time, 1) + ':'
                       + Substring(CAST(Active_start_time AS varchar(6)), 2, 2)
                       + ':' + Substring(CAST(Active_start_time AS varchar(6)),
                                         4, 2) AS varchar(8))
                  WHEN LEN(Active_Start_Time) = 6
                  THEN CAST(LEFT(Active_Start_Time, 2) + ':'
                       + Substring(CAST(Active_start_time AS varchar(6)), 3, 2)
                       + ':' + Substring(CAST(Active_start_time AS varchar(6)),
                                         5, 2) AS varchar(8))
                  WHEN Active_Start_Time = 0 THEN '00:00:00'
             END AS datetime) AS Start_Time,
        DATEADD(ss,
                CAST(SUBSTRING(RIGHT('000000'
                                     + CAST(last_run_duration AS VARCHAR(06)),
                                     6), 1, 2) AS INT) * 3600
                + CAST(SUBSTRING(RIGHT('000000'
                                       + CAST(last_run_duration AS VARCHAR(06)),
                                       6), 3, 2) AS INT) * 60
                + CAST(SUBSTRING(RIGHT('000000'
                                       + CAST(last_run_duration AS VARCHAR(06)),
                                       6), 5, 2) AS INT),
                CAST(CASE WHEN LEN(Active_Start_Time) = 5
                          THEN CAST('0' + LEFT(Active_Start_Time, 1) + ':'
                               + Substring(CAST(Active_start_time AS varchar(6)),
                                           2, 2) + ':'
                               + Substring(CAST(Active_start_time AS varchar(6)),
                                           4, 2) AS varchar(8))
                          WHEN LEN(Active_Start_Time) = 6
                          THEN CAST(LEFT(Active_Start_Time, 2) + ':'
                               + Substring(CAST(Active_start_time AS varchar(6)),
                                           3, 2) + ':'
                               + Substring(CAST(Active_start_time AS varchar(6)),
                                           5, 2) AS varchar(8))
                          WHEN Active_Start_Time = 0 THEN '00:00:00'
                     END AS datetime)) AS End_Time,
        active_start_time,
        notify_email_operator_id,
        Category_Name,
        last_run_date,
        date_modified,
        enabled
FROM    Jobs
WHERE   ( enabled = 1 )
        and server in ( @Server )
        and Cast(Cast(LEFT(last_run_date, 4) as char(4)) + '/'
        + Cast(SUBSTRING(cast(last_run_date as char(8)), 5, 2) as char(2))
        + '/' + cast(right(last_run_date, 2) as char(2)) as datetime) in (
        @Last_Run_Date )
ORDER BY Server