Canmnt update or delete Job definitions | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Canmnt update or delete Job definitions

Hi all. We recently migrated one of our development sql servers to windows 2003, with sql2000 Enterprise on it. The new machine has a different name, and runs under a different account, to the old server. The old server had analysis services on it. Ive not got round to putting it on this new dev server yet.<br /><br />I copied across all my jobs from the old server. However, they are all failing to run, with the error…<br /><br />"Unable to perform a SETUSER to the requested username ‘capnetsql’ because the username is invalid for database ‘msdb’. The step failed."<br /><br />Ok, thats fine, I just need to set the jobs to run under a different account. But I cant do this because I get the error<br /><br />—————————<br />Microsoft SQL-DMO (ODBC SQLState: 42000)<br />—————————<br />Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server.<br />—————————<br />OK <br />—————————<br /><br />Im now stuck with a job which fails every night, that I cant delete or disable. <br /><br />Any suggestions? <br /><br />Ideally id rather not hack around in the system tables if i can helpit because its a new dev server and I dont want things getting crufty at this early stage <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br />Thanks<br /><br /><br />
I have found previously the only way to get round this is to manually update sysjobs. If it’s any comfort it is a simply update and it doesn’t appear to make things crufty! Tom Pullen
DBA, Oxfam GB
Thanks Thomas. Like you say it was straight forward update of ‘originating_server’.
I had worried I would have to delete the job, then job steps and schedules etc etc
KBA;en-us;281642 for information. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.