CREATE TABLE #Days (
    ID INT PRIMARY KEY,
    Days VARCHAR(100)) ;

;
WITH    Numbers
          AS (SELECT
                0 AS Number
              UNION ALL
              SELECT
                1
              UNION ALL
              SELECT
                2
              UNION ALL
              SELECT
                3
              UNION ALL
              SELECT
                4
              UNION ALL
              SELECT
                5
              UNION ALL
              SELECT
                6),
        Base
          AS (SELECT
                POWER(2, number) Num
              FROM
                Numbers
              UNION ALL
              SELECT
                0),
        Combos
          AS (SELECT
                B1.Num B1,
                B2.Num B2,
                B3.Num B3,
                B4.Num B4,
                B5.Num B5,
                B6.Num B6,
                B7.Num B7,
                B1.Num + B2.Num + B3.Num + B4.Num + B5.Num + B6.Num + B7.Num AS Total
              FROM
                Base B1
              INNER JOIN Base B2
                ON B1.Num > B2.Num
              INNER JOIN Base B3
                ON B2.Num > B3.Num
                   OR B2.Num = 0
                   AND B3.Num = 0
              INNER JOIN Base B4
                ON B3.Num > B4.Num
                   OR B3.Num = 0
                   AND B4.Num = 0
              INNER JOIN Base B5
                ON B4.Num > B5.Num
                   OR B4.Num = 0
                   AND B5.Num = 0
              INNER JOIN Base B6
                ON B5.Num > B6.Num
                   OR B5.Num = 0
                   AND B6.Num = 0
              INNER JOIN Base B7
                ON B6.Num > B7.Num
                   OR B6.Num = 0
                   AND B7.Num = 0)
    INSERT INTO
        #Days (ID, Days)
        SELECT
            Total,
            STUFF((SELECT
                    ',' + CASE Val
                            WHEN 1 THEN 'Sunday'
                            WHEN 2 THEN 'Monday'
                            WHEN 4 THEN 'Tuesday'
                            WHEN 8 THEN 'Wednesday'
                            WHEN 16 THEN 'Thursday'
                            WHEN 32 THEN 'Friday'
                            WHEN 64 THEN 'Saturday'
                          END
                   FROM
                    (SELECT
                        Total,
                        B1,
                        B2,
                        B3,
                        B4,
                        B5,
                        B6,
                        B7
                     FROM
                        Combos) C UNPIVOT ( Val FOR Base IN (B1, B2, B3, B4,
                                                             B5, B6, B7) ) as Unpvt
                   WHERE
                    Val > 0
                    AND Total = Main.Total
                   ORDER BY
                    Val
                  FOR
                   XML PATH('')), 1, 1, '')
        FROM
            Combos Main
        ORDER BY
            Total ;

SELECT
    Name,
    (SELECT
        Name,
        CONVERT(VARCHAR(50), CAST(STUFF(STUFF(active_start_date, 5, 0, '-'), 8,
                                        0, '-') + ' '
        + STUFF(STUFF(RIGHT('000000' + CAST(active_start_time AS VARCHAR(6)),
                            6), 3, 0, ':'), 6, 0, ':') AS DATETIME), 100) AS FirstRun,
        CONVERT(VARCHAR(50), CAST(STUFF(STUFF(active_end_date, 5, 0, '-'), 8,
                                        0, '-') + ' '
        + STUFF(STUFF(RIGHT('000000' + CAST(active_end_time AS VARCHAR(6)), 6),
                      3, 0, ':'), 6, 0, ':') AS DATETIME), 100) AS FinalRun,
        CASE freq_type
          WHEN 1 THEN 'One-Time'
          WHEN 4 THEN 'Daily'
          WHEN 8 THEN 'Weekly'
          WHEN 16 THEN 'Monthly'
          WHEN 32 THEN 'Monthly'
          WHEN 64 THEN 'SQL Agent Start'
          WHEN 128 THEN 'System Idle'
        END AS Frequency,
        CASE freq_type
          WHEN 1 THEN NULL
          WHEN 4
          THEN 'Every ' + CAST(freq_interval AS VARCHAR(10)) + ' Day(s)'
          WHEN 8 THEN (SELECT
                        Days
                       FROM
                        #Days
                       WHERE
                        ID = Schedule.freq_interval)
          WHEN 16
          THEN 'On day ' + CAST(freq_interval AS VARCHAR(10)) + ' of every '
               + CAST(freq_recurrence_factor AS VARCHAR(10)) + ' Month(s)'
          WHEN 32
          THEN 'On the ' + CASE freq_relative_interval
                             WHEN 1 THEN '1st'
                             WHEN 2 THEN '2nd'
                             WHEN 4 THEN '3rd'
                             WHEN 8 THEN '4th'
                             WHEN 16 THEN 'Last'
                           END + ' ' + CASE freq_interval
                                         WHEN 1 THEN 'Sunday'
                                         WHEN 2 THEN 'Monday'
                                         WHEN 3 THEN 'Tuesday'
                                         WHEN 4 THEN 'Wednesday'
                                         WHEN 5 THEN 'Thursday'
                                         WHEN 6 THEN 'Friday'
                                         WHEN 7 THEN 'Saturday'
                                       END + ' of every '
               + CAST(freq_recurrence_factor AS VARCHAR(10)) + ' Month(s)'
        END AS Days,
        CASE freq_subday_type
          WHEN 1 THEN 'Once'
          WHEN 2
          THEN 'Every ' + CAST(freq_subday_interval AS VARCHAR(10))
               + ' Second(s)'
          WHEN 4
          THEN 'Every ' + CAST(freq_subday_interval AS VARCHAR(10))
               + ' Minute(s)'
          WHEN 8
          THEN 'Every ' + CAST(freq_subday_interval AS VARCHAR(10))
               + ' Hour(s)'
        END AS Timing
     FROM
        msdb.dbo.sysschedules Schedule
     INNER JOIN msdb.dbo.sysjobschedules JobSchedule
        ON Schedule.schedule_id = JobSchedule.schedule_id
     WHERE
        job_id = Job.job_id
    FOR
     XML AUTO,
         TYPE) AS Schedules
FROM
    msdb.dbo.sysjobs Job
FOR   
    XML AUTO,
        TYPE;