Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Database Job Schedules Expand / Collapse
Author
Message
Posted Tuesday, December 30, 2008 11:05 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 27, 2014 11:20 AM
Points: 255, Visits: 394
Comments posted to this topic are about the item Database Job Schedules


Post #627819
Posted Wednesday, December 31, 2008 12:27 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 3:41 AM
Points: 407, Visits: 79
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

Post #627856
Posted Wednesday, December 31, 2008 5:52 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 27, 2014 11:20 AM
Points: 255, Visits: 394
http://technet.microsoft.com/en-us/library/ms187354(SQL.90).aspx


Post #627982
Posted Wednesday, December 31, 2008 6:41 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 9:42 AM
Points: 1,534, Visits: 2,260
Good question!

The Redneck DBA
Post #628019
Posted Wednesday, December 31, 2008 7:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 27, 2014 11:20 AM
Points: 255, Visits: 394
Thanks Jason. And yes, it IS addictive. I can't get enough of this site.


Post #628046
Posted Wednesday, December 31, 2008 7:47 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 11:59 AM
Points: 1,937, Visits: 2,106
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.
Post #628073
Posted Wednesday, December 31, 2008 8:43 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 27, 2014 11:20 AM
Points: 255, Visits: 394
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.



Post #628125
Posted Thursday, January 1, 2009 3:11 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,439, Visits: 1,400
After a long time a excellent question... :)


Post #628384
Posted Friday, January 2, 2009 3:14 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:53 PM
Points: 1,388, Visits: 3,039
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.
Post #629136
Posted Tuesday, January 6, 2009 8:39 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:12 AM
Points: 31,284, Visits: 15,746
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
Post #630638
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse