• Plenty of solutions already in place and I tried to built something from all:

    select next_run_date,next_run_time,

    CONVERT(CHAR(8), next_run_date, 112)+

    CONVERT(datetime,STUFF(STUFF(RIGHT('000000' + CONVERT(VARCHAR(8), next_run_time), 6), 5, 0, ':'), 3, 0, ':'),108) next_datetime

    from dbo.sysjobschedules

    But, every solution looks good 🙂