I was getting the error @schedule_uid is not a parameter for procedure sp_add_jobschedule, when executing a  script that was generated by Microsoft SQL Server Management Studio.

 

This had something to do with Microsoft SQL Server 2005 vs Microsoft SQL Server 2008. On Microsoft SQL Server 2005 this parameter is @schedule_id and on Microsoft SQL Server 2008 this parameter is @schedule_uid (and from an other type)

 

But when you remove this parameter, the script will work on both SQL Server 2005 as on Microsoft SQL Server 2008

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.