Renaming SQl Server Agent Jobs

Posted on 2011-10-27
Last Modified: 2012-05-12
Is there a known stored procedure or way that i can rename SQL Server Agent Jobs other than doing it from the SSMS?
Question by:mamlaide
    LVL 68

    Accepted Solution

    EXEC msdb.dbo.sp_update_job 'job_name', @new_name = 'new_job_name'

    LVL 7

    Assisted Solution


    USE msdb
    EXECUTE sp_update_job @job_name = 'YourJobName', @new_name = 'NewJobName';


    Author Closing Comment

    Both comments did help me arrive at the solution
    LVL 68

    Expert Comment

    Interesting that he got half the points for posting a slight variation of what I had posted an hour before.  Hopefully he'll be as helpful to you on future questions.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    734 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

    22 Experts available now in Live!

    Get 1:1 Help Now