Post reply

MSX Server error 14274

  • December 21, 2003 at 7:55 am

    #59052

    Hi,

    I'm trying to delete an old backup job,

    I get the message, 14274 cannot change or delete job that originated from an msx server

    What is an MSX Server, and how to I find it to delete the job?

    Thanks

  • December 21, 2003 at 8:05 am

    #487360

    http://support.microsoft.com/?id=281642

    --Jonathan



    --Jonathan

  • December 21, 2003 at 12:55 pm

    #487365

    If you execute the following, you should be OK.

    updatemsdb..sysjobs

    setoriginating_server = CONVERT(NVARCHAR(30), SERVERPROPERTY('ServerName'))

    go

  • December 23, 2003 at 11:21 am

    #487655

    johnathna, jxflagg

    Thanks for the tips

  • December 23, 2003 at 11:58 am

    #487658

    Anyway you should first check wich one is the master server and if you wont delete the job from it, and provably defect the target server if you don't need it anymore.

  • April 26, 2007 at 6:25 pm

    #702831

    Simple i tried this and it worked as my friend said above all you have to do is

     

    1.  log into query analyzer and select the MSDB database

    2. Run a update script on the packages that you are trying to edit/delete set the originating column value to name of the server. in my example 'SqlServerMaster' is the name of my server

    3.

    USE MSDB

    Update

    msdb..sysjobs set

    originating_server= 'SqlServerMaster'

  • September 10, 2009 at 6:27 am

    #1051686

    Worked for me. Alternatively you can manually update just the jobs you want by querying the sysjobs table in MSDB.

    Note: This only applies to SQL Server 2000 I think as the field is different in 2005

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply