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


Database Job Schedules


Database Job Schedules

Author
Message
jdshabat
jdshabat
Old Hand
Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)

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



Yousaf Khan
Yousaf Khan
SSC-Addicted
SSC-Addicted (465 reputation)SSC-Addicted (465 reputation)SSC-Addicted (465 reputation)SSC-Addicted (465 reputation)SSC-Addicted (465 reputation)SSC-Addicted (465 reputation)SSC-Addicted (465 reputation)SSC-Addicted (465 reputation)

Group: General Forum Members
Points: 465 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
Old Hand
Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)

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



TheRedneckDBA
TheRedneckDBA
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2556 Visits: 2610
Good question!

The Redneck DBA
jdshabat
jdshabat
Old Hand
Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)

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



Chris Harshman
Chris Harshman
SSCertifiable
SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)

Group: General Forum Members
Points: 5088 Visits: 4010
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
Old Hand
Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)

Group: General Forum Members
Points: 301 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
SSCertifiable
SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)

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



john.arnott
john.arnott
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2036 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 (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)

Group: Administrators
Points: 65119 Visits: 19118
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