Recently I was trying to help someone on Microsoft Newsgroups with issue with Linked Server. When inserting into Linked Server directly via the SQL Statement
Category: SQL Errors
Error 14274: Cannot add, update, or delete a job (or its steps or schedule) that originated from an MSX server.
You can get this error when trying to modify the properties of a Job after the SQL Server has been renamed or cloned into another
Error 18456, Severity 14: Login Failed States
The document referenced below explains all the states, this is just a summary. State Description 1 Only state returned in SQL 2000. Seems to be