Microsoft KB Archive/908243

= BUG: You receive an &quot;Error 14269&quot; error message when you try to modify the SQL Server Agent job if the combination of the computer name and the instance name is more than 30 characters in SQL Server 2000 =

Article ID: 908243

Article Last Modified on 11/2/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 2000 Developer Edition
 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Personal Edition

-



BUG #: 472192 (SQL Server 8.0)



SYMPTOMS
In Microsoft SQL Server 2000, you identify a named instance by using a combination of the computer name and the instance name that is specified as. If the combination of the computer name and the instance name is more than 30 characters, you can create a new SQL Server Agent job. Additionally, the SQL Server Agent job runs successfully. However, if the combination of the computer name and the instance name is more than 30 characters, you cannot modify the SQL Server Agent job. When you try to modify the SQL Server Agent job, you receive the following error message:

Error 14269: Job ' ' is already targeted at server

' '. The job was not saved.

Note In this error message,  is a placeholder for the name of the SQL Server Agent job, and   is a placeholder for the combination of the computer name and the instance name.



CAUSE
This issue occurs because the sp_add_jobserver stored procedure cannot run correctly.

In SQL Server, the computer name and the instance name are stored as the nvarchar (30) data type column in several system tables. Alternatively, the computer name and the instance name are defined as input parameters that have the nvarchar (30) data type for several stored procedures. These stored procedures are needed to modify the SQL Server Agent job. If the combination of the computer name and the instance name is more than 30 characters, the sp_add_jobserver stored procedure cannot run correctly.



WORKAROUND
To work around this issue, use one of the following methods:
 * Reinstall SQL Server, and make sure that the combination of the computer name and the instance name is fewer than 30 characters.
 * If you must use a combination of the computer name and the instance name that is more than 30 characters, delete the SQL Server Agent job. Then, re-create the SQL Server Agent job, and include the changes that you want to make.

Note If the SQL Server Agent job is not a maintenance plan, you can follow these steps:
 * Generate a SQL script file for the SQL Server Agent job.
 * Modify the SQL script in the file to include the changes that you want to make.
 * Run the SQL script to re-create the SQL Server Agent job.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section.

