Home > Server Error > Server Error 14274

Server Error 14274

You are a GENIUS!Reply aymeric October 15, 2009 7:56 pmThanks, solved my problemReply P.L. He looks remarkabally like you.. Run system stored procedure to drop server sp_dropserver ‘old server name' c. Microsoft says that i need to change the name server to the old name, delete the jobs… To complicated and un-usefull for a production server! http://internetmairie.com/server-error/unable-to-resolve-server-hostname-exiting-with-http-500-server-error-39-10-0004-39.html

How to explain the use of high-tech bows instead of guns Why did the Ministry of Magic choose an ax for carrying out a death sentence? SqlServer-query Disclaimer SQL Server Database MaintenanceSQL Server Error 14274 - Cannot add, update or delete a job (or its steps or schedules) that originated from an MSX server « SQL Server Rate this:Share this:Click to share on Twitter (Opens in new window)Share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Google+ (Opens in You cannot edit your own events. http://blog.sqlauthority.com/2006/12/20/sql-server-fix-error-14274-cannot-add-update-or-delete-a-job-or-its-steps-or-schedules-that-originated-from-an-msx-server-the-job-was-not-saved/

Problem solved. Fix --Verify Server Name SELECT @@servername If SQL name is not correct run. -- if no sp_dropserver <'nameReturned'> -- and then sp_addserver <'correctServername'> , 'local' Print 'Your server name has now Terms of Use. You need to NULL it before you EXEC sp_add_job the second time, according to this post:http://social.msdn.microsoft.com/Forums/sqlserver/en-US/b3c5fc56-e99c-42e8-9f67-9074bf0bf957/adding-a-job-to-sql-agent?forum=transactsqlSET @jobId = NULL;GraemeThe Oracle ScottPletcher Aged Yak Warrior USA 550 Posts Posted-11/12/2013: 17:30:48

Should there really be 1E6 ohm resistance between an anti-static wrist strap and a pc? Nupur Dave is a social media enthusiast and and an independent consultant. The job was not saved.Reason: SQL Server 2000 supports multi-instances, the originating_server field contains the instance name in the format ‘server\instance'. more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation

Additionally you can find more discussion/suggestions here ... To resolve this problem by using manual method (script out) 1. just like your long lost brother. It’s a known problem with SQL2000 SP3.

Thanks a lot.Reply Ning Xu September 5, 2012 3:31 pmI've bumped this issue just today while maintaining an acient sql2000 instance. December 20, 2006Pinal DaveSQL, SQL Server, SQL Tips and Tricks97 commentsTo fix the error which occurs after the Windows server name been changed, when trying to update or delete the jobs Pending vdi error codes Restore speed details Help, my transaction log file is huge! JSKReply kunal August 13, 2010 11:42 amGreat…Thanks for your helpReply Bryan September 2, 2010 7:46 pmThanks a load… You're GREATReply Lori September 23, 2010 7:49 pmJust what I needed!

it did work..if you want to disable a certain job.. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=186495 rosetulip Starting Member 15 Posts Posted-07/01/2013: 21:25:28 I followed the links to update server name, I still have the same error. In my case, the scheduled job had been around for over 6 years, and the server had been renamed about 5 years ago.  The job has continued to run and noone Thanks.Reply Bob March 31, 2015 8:46 pmi cannot see the originating_server column there is originating_server_id column.Reply Pinal Dave April 3, 2015 9:57 amBob - What is the actual problem?Reply « Older

The recommended approach is to rename the server to its original name, script out your jobs, rename the server back again, and recreate your jobs. check over here Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are You may download attachments. You cannot edit other events.

You helped me sooo much!Thanks a lot! MS was totally useless on how to fix this problem. thanks a lot, my problem has been solved. http://internetmairie.com/server-error/server-error-in-application-lync-server-internal-website.html i have a system shutdown coming up in the weekend and i cant stop this job...

All Rights Reserved. Otherwise when you will try to add, update or delete a job on sql server, it will throw below error. Greetings from Argentina!

Thanks a lot for always sharing useful stuff!!Reply Kaushal February 1, 2011 12:23 pmThanks Pinal.

Why This is a known issue as reported here. Execute the script generated by step 2. It's a known problem with SQL2000 SP3.Fix/Workaround/Solution:In order to solve the problem you should perform the following steps: From the Query Analyzer run following steps in order: SELECT @@servernameand Posted Tuesday, January 12, 2010 8:59 PM SSC Veteran Group: General Forum Members Last Login: Thursday, March 29, 2012 5:22 AM Points: 260, Visits: 800 If you want to delete the

Thanks Again, Ed KReply Saravana Kumar September 21, 2011 7:21 pmThanksReply k September 27, 2011 4:15 amPinal, by any chance do you happen to know Sumit Dave? Come on over! Both my production server and standby server names have been set properly. http://internetmairie.com/server-error/server-error-unable-to-connect-to-fastcgi-server-iis6.html No trackbacks yet.

Home About Home > SQL 2000, SQL Errors > Error 14274: Cannot add, update, or delete a job (or its steps or schedule) that originated from an MSXserver. Thank you.Reply Shabir August 1, 2013 6:19 amHi, I need some hep regarding the SQL 2000.We have been using SQL2000 with CalSys (KROHNE Oil & Gas proprietry) whereby the SQL feeds Disproving Euler proposition by brute force in C Is it unethical of me and can I get in trouble if a professor passes me based on an oral exam without attending You're the best!Reply ott September 28, 2010 6:03 amI just ran it like this DELETE FROM msdb..sysjobsand it took them all off for me, if you don't want to remove them

I had 1/2 my jobs with the old server name and 1/2 with the new server name. The job was not saved.Reason: SQL Server 2000 supports multi-instances, the originating_server field contains the instance name in the format ‘server\instance'. Script out all of the jobs and then delete them. The job was not saved.

Error 14274: Cannot add, update, or delete a job Rate Topic Display Mode Topic Options Author Message Mani-584606Mani-584606 Posted Tuesday, January 12, 2010 3:35 PM Mr or Mrs. 500 Group: General SQL Server Error 14274 : Cannot add, update or delete a job (or its steps or schedules) that originated from an MSX server. http://support.microsoft.com/kb/281642 After the Windows server name been changed, when trying to update or delete the jobs previously created in a SQL Server 2000 instance, you may receive the following error message: Run the below query SELECT @@servername b.

Thanks again!Reply Clayton Santos September 13, 2012 12:09 amHi, Thank you for help.Excelent.Santos, Clayton AReply software company in bhubaneswar October 16, 2012 11:18 amAs a database working in SQL Server is SQLAuthority.com Performance TuningSQL TipsSQL PuzzleBig DataBlog StatsFix Your SQL Server Facebook Twitter Google+ LinkedIn YouTube RSSHomeInterviewsWeekly Questions and AnswersVideo LearningSQL in Sixty SecondsVideo CoursesSQL BooksAll ArticlesDownloadsHire MeSQL SERVER - Fix : sql-server-2000 jobs share|improve this question edited May 31 '12 at 12:18 Leigh Riffel 18.4k1053127 asked May 31 '12 at 7:30 AmmarR 1,97921225 add a comment| 1 Answer 1 active oldest votes But jobs related to this maintenance plan in SQL Agent are NOT deleted and I tried to delete manually but still getting the same above error.please advice thanks Post #846604 -

So now whenever you will try to access jobs information it will refer to old server. If I run separately, it works fine.The two jobs are testdbname jobtestnewdb jobIt comes up with the following errorsI got many these messageMsg 14274, Level 16, State 1, Procedure sp_add_job, Line Even for the default instance of the server, the actual server name is used instead of ‘(local)'.