[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1541
  • Last Modified:

Renaming SQl Server Agent Jobs

Is there a known stored procedure or way that i can rename SQL Server Agent Jobs other than doing it from the SSMS?
0
mamlaide
Asked:
mamlaide
  • 2
2 Solutions
 
Scott PletcherSenior DBACommented:
EXEC msdb.dbo.sp_update_job 'job_name', @new_name = 'new_job_name'

0
 
MrAliCommented:

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


0
 
mamlaideAuthor Commented:
Both comments did help me arrive at the solution
0
 
Scott PletcherSenior DBACommented:
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.
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now