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

2:20 PM , , , , , 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.

Unknown

Some say he’s half man half fish, others say he’s more of a seventy/thirty split. Either way he’s a fishy bastard.

0 comments:

Subscribe to: Post Comments (Atom)