[Webinar] Streamline your web hosting managementRegister Today


can not change job step

Posted on 2004-11-01
Medium Priority
Last Modified: 2008-02-26

I recently rebuilt my sql dev server, and restore db from my pdn server...it went fine.

But I need to change the job step on dev server.

I got this:

Error 14274: cant add, update or del a job that originated from an msx server.......

Any solutions?  thx
Question by:mcrmg
  • 2
LVL 13

Expert Comment

ID: 12463647
LVL 10

Assisted Solution

AustinSeven earned 200 total points
ID: 12463655
I'm assuming that you have managed to recreate the job on the new server by restoring the MSDB database.  The error might be because the job's owner needs changing.   Go into the job's properties and you will see an 'owner' field.   If it isn't SA, you could try setting it to SA to see what happens.  

LVL 13

Accepted Solution

danblake earned 400 total points
ID: 12463662
You basically need rename the originating_server in sysjobs table if this was not the source server.

Author Comment

ID: 12463890
okay,  I changed the name is sysjob in msdb.......thx

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question