-
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?
-
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.
-
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
-
Forum Rules
|
|