Trying to Change an Existing Schedule and Edit Job Steps Using T-SQL

• ducksql@gmail.com

  SSCrazy

  Points: 2826

  More actions

  January 30, 2012 at 10:58 am

  #250420

  I learned the other day to use sp_add_jobschedule to add a Schedule to an existing job. Is there another Stored Procedure that allows me to change an exisitng schedule?

  Also, is there a Stored Procedure to edit Steps in an existing job?

  Thank you.

  Steve

• GSquared

  SSC Guru

  Points: 260824

  More actions

  January 30, 2012 at 11:11 am

  #1440164

  sp_update_schedule: http://msdn.microsoft.com/en-us/library/ms187354.aspx

  sp_update_job: http://msdn.microsoft.com/en-us/library/ms188745.aspx

  sp_add_jobstep: http://msdn.microsoft.com/en-us/library/ms187358.aspx

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• ducksql@gmail.com

  SSCrazy

  Points: 2826

  More actions

  January 30, 2012 at 12:42 pm

  #1440198

  Thank you very much. 🙂

• Ed7

  SSCrazy Eights

  Points: 8519

  More actions

  May 21, 2014 at 3:25 pm

  #1715507

  Questions:

  I have a SQL Server 2008 R2 and have 100 SQL Agent jobs listed with different schedule and time stamps.

  Now, I needed to add addtion 7 hours to the existing those SQL Agent job's schedule time.

  How can I do that in T-SQL.

  Please help and thank in advance.

  Thank you.

  Edwin