Get a list of Job schedules in SQL Server 2005

Posted on 2010-01-06
Last Modified: 2012-05-08
Is there a way to get a list of all jobs and their schedules from the SQL Server Agent on SQL Server 2005?

Question by:kasiencja
    LVL 75

    Accepted Solution

    select * from msdb.dbo.sysjobs
    select * from msdb.dbo.sysjobschedules

    Author Closing Comment

    LVL 5

    Expert Comment

    To get a more readable result set, follow the steps here:

    You create a function in msdb, then run a script against it. Results look something like this.

    name                      active_start_time       ScheduleDscr
    SqlMon-4                0:00                              Automatically starts when SQLServerAgent starts.
    SqlMon All              6:02                              Every day at 6:02
    SqlAudit - Scan     12:35                            Every 1 week(s) on Monday at 12:35


    Author Comment

    Thanks for the last post; it does make life a lot easier with this layout.  I'm sorry I don't think/not sure I can split the points at this time.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now