SQL Server Performance Forum – Threads Archive
Canmnt update or delete Job definitionsHi 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
KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;281642 for information. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.