• Nice script but it is limited in what it reports.

    1) Does not work in SQL Server 2000 because sp_help_jobschedule returns less columns in 2000

    2) Does not support multiple Job schedules such as onetimes

    3) Only list jobs that are scheduled to run multiple times a day

    It is a very nice script to review the runtime of Jobs scheduled to run multiple times day on SQL Server 2005

    David Bird