Home > Fix Error > Sp_add_jobserver

Sp_add_jobserver

Contents

I deleted the jobs and maintenance plan since they were simple. Please check this post for more information. but thanks for the link –AmmarR May 31 '12 at 7:44 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign You cannot delete other topics.

All product and company names are trademarks or registered trademarks of their respective owners. I have also placed print statements at various places in the script to be sure that the the correct commands are being generated. Email check failed, please try again Sorry, your blog cannot share posts by email. Label names must be unique within a query batch or stored procedure. check these guys out

Sp_add_jobserver

Thursday, 19 April 2012 22:04 Category: SQL Written by Jamin Quimby Hits: 4671 FIX - Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated 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 Leave new yoodles August 13, 2009 11:23 pmGreat work, this really helped me out. But, I haven't changed the server name and if that were case why would the first one work but the rest of them not?

Execute the script generated by step 2. Wayne E. You cannot delete other events. I am running SQL Server 2005 and the sysjobs table on my server does not containt a column named that.

You cannot delete your own topics. You cannot post events. 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'. http://jaminquimby.com/servers/93-sql/110-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 Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server.

I just tried running it on the server from SSMS and received the following (which is the same error as before): (I made the change from '(local)' to '') Job Browse other questions tagged sql-server-2000 jobs or ask your own question. Fix-Workaround-Solution To fix this problem, one option to drop old server name using system stored procedure in sql server and then add new server name and restart the services. Send to Email Address Your Name Your Email Address Cancel Post was not sent - check your email addresses!

Sp_delete_job

You cannot delete your own events. To resolve this problem by using manual method (script out) 1. Sp_add_jobserver 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? Sp_dropserver Even for the default instance of the server, the actual server name is used instead of ‘(local)’.

originating_server_idOne more link: 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/Can you post the results? Reason: SQL Server 2000 supports multi-instances, the originating_server field contains the instance name in the format server\instance. Naturally with dummy data.Thanks.Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com Friday, October 16, 2009 8:29 PM Reply | Quote Moderator 0 Sign in to vote USE [master] Copyright 2008 - 2015 Yohz Ventures Sdn Bhd.

If either were the case, wouldn't that cause all 'sp_add_job' calls to fail, not just all those after the first one? That loop is suspect...Can you insert a the following 15sec delay into the WHILE loop and test? sql-server-2000 jobs share|improve this question edited May 31 '12 at 12:18 Leigh Riffel 18.6k1055128 asked May 31 '12 at 7:30 AmmarR 1,98921225 add a comment| 1 Answer 1 active oldest votes All Forums SQL Server 2008 Forums Transact-SQL (2008) Cannot add, update, or delete a job (or its steps Reply to Topic Printer Friendly Author Topic rosetulip Starting Member 15 Posts

PDF Downloads SQL Coding Standards SQL FAQ DownloadDownload SQL SERVER 2016 (FREE)Exclusive Newsletter SQL Interview Q & ASearch © 2016 All rights reserved. The job was not saved. Leisure and Entertainment What makes up $17,500 cost to outfit a U.S.

You cannot edit other events.

Menu HomeServersWork StationsPrograming The Lonely DBA Challenges (and solutions) from a DBA guy doing DBA stuff. Script out all of the jobs and then delete them. I'm from a highly competitive and fast-paced world too, the IT industry, and this space will be used to share some challenges I face daily on my career. SQLAuthority.com Home | Weblogs | Forums | SQL Server Links Search: Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About Please start any

SQL Server Error 14274 : Cannot add, update or delete a job (or its steps or schedules) that originated from an MSX server. Document history 7/24/2008 Initial release. You cannot delete other posts. Since I only have a handful of jobs, I just went into the sysjobs table and manual fixed the entries.

You cannot edit HTML code.