.png)
Sql Server Error: @schedule_uid is not a parameter for procedure sp_add_jobschedule.
@schedule_uid is not a parameter for procedure sp_add_jobschedule.Recently had to resolve an issue with this error when sending in a SQL script. We right clicked a server job and when to:
Script Job As > CREATE TO > New Query Editor Window
in SQL Server 2008. The script was going to be ran on SQL Server 2005 server.
On SQL Server 2005 the parameter is @schedule_id and on SQL Server 2008 this parameter is @schedule_uid. If you remove the parameter this will allow the script to be ran on both 2005 and 2008.
