Results 1 to 3 of 3

Thread: Job errors

  1. #1
    Join Date
    Aug 2004
    Posts
    188

    Job errors

    I get this error when i try to modify or fix a job

    Cannot add, update, or delete a job(or ists steps or shcedules) that aoriginated from an MSX Server.

    error 14274

    Why is this? Any ideas. I checked the sysjobs in the msdb and they have the correct server name for the jobs?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    If you enabled multi server administration, have to modify job on master server. If not, check job's originating_server in msdb..sysjobs and it has to be local sql server name.

  3. #3
    Join Date
    Feb 2003
    Location
    Aussie Land
    Posts
    114
    I usually get this error after restoring the MSDB database on a new server. Solution, update the field 'oringinating_server' with the name of the server in msdb.dbo.sysjobs.
    However do it at your own risk as MS do not recommend updating system tables.

    Can you confirm, that the server name in the field 'originating_server' in the table msdb.dbo.sysjobs has the correct servername?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •