Sql Server Error: @schedule_uid is not a parameter for procedure sp_add_jobschedule.

2:20 PM C# , Programming , SQL , Sql Errors , Sql Server , William Arends 0 Comments

@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.