SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database Job Schedules


Database Job Schedules

Author
Message
jdshabat
jdshabat
SSC-Addicted
SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)

Group: General Forum Members
Points: 491 Visits: 450
Comments posted to this topic are about the item Database Job Schedules



Yousaf Khan
Yousaf Khan
Mr or Mrs. 500
Mr or Mrs. 500 (597 reputation)Mr or Mrs. 500 (597 reputation)Mr or Mrs. 500 (597 reputation)Mr or Mrs. 500 (597 reputation)Mr or Mrs. 500 (597 reputation)Mr or Mrs. 500 (597 reputation)Mr or Mrs. 500 (597 reputation)Mr or Mrs. 500 (597 reputation)

Group: General Forum Members
Points: 597 Visits: 113
Hi
I am unable to find the sp or command like sp_update_schedule
i have searched it in sql 2005 & 2000 but there is no procedure with this name

i got the procedure sp_update_jobschedule with @name parameter


Regards,

Yousaf khan
jdshabat
jdshabat
SSC-Addicted
SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)

Group: General Forum Members
Points: 491 Visits: 450
http://technet.microsoft.com/en-us/library/ms187354(SQL.90).aspx



TheRedneckDBA
TheRedneckDBA
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4137 Visits: 2613
Good question!

The Redneck DBA
jdshabat
jdshabat
SSC-Addicted
SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)

Group: General Forum Members
Points: 491 Visits: 450
Thanks Jason. And yes, it IS addictive. I can't get enough of this site.



Chris Harshman
Chris Harshman
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10633 Visits: 4657
Unsure another good question with bad answer choices unfortunately.

http://technet.microsoft.com/en-us/library/ms178560(SQL.90).aspx
says: "sp_update_jobschedule is provided for backward compatibility only" so it still works, just Microsoft in their infinite wisdom decided to change it along with a number of other low level plumbing items in SQL Server between 2000 and 2005. Seeing how many people selected sp_update_jobschedue looks like I'm not the only one who fell into the trap, and I try not to cheat when answering these questions, just go on the knowledge that's already in my head.
jdshabat
jdshabat
SSC-Addicted
SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)

Group: General Forum Members
Points: 491 Visits: 450
The point of the question was to get folks to learn about the fact that while sp_update_jobschedule is available, it is not the best answer, as it is only available for backward compatibility purposes. That's why the question included the critical phrase "(even beyond SQL Server 2008)", which was intended to trigger the notion that a change is in the air.

Chris, folks on my team had the same reaction, so I've been expecting this for a few weeks. I really appreciate the feedback. And as someone who has also felt "duped" by bad answer choices, I am wholly appreciative of your concerns. However, I hope you'll agree that the ability to manipulate schedules independent of jobs is a great feature in SQL Server 2005.



Anipaul
Anipaul
SSCrazy Eights
SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)

Group: General Forum Members
Points: 9653 Visits: 1407
After a long time a excellent question... Smile



john.arnott
john.arnott
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3524 Visits: 3059
Good question, pointing out the change in stored procedure name.

Not to sound as though a direct update of system tables ever would be a good idea, I do wonder if updating msdb.dbo.sysjobschedules.next_run_time would have made the job run at 21:00. Again, I ask only for insight as to the under-the-hood operation of the scheduler.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)

Group: Administrators
Points: 142238 Visits: 19424
jdshabat has a great point in that he devised the question to show the change.

Chris, you are tackling the questions correctly, use your memory and see if you know. However if you get it wrong, it's not a competition in that you aren't competent. It's a competition in that if you know the trivia here, you get it right.

I doubt many people know this, but the point of the QOD here is to bring it to your attention that this proc has been introduced as the new way to manage schedules.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search