rwheeler23
asked on
How to copy SQL jobs from one SQL instance to another.
I am trying to copy several SQL jobs from our test server to production. When I run the scripts to drop and create these jobs I get messages like these. What must I do to these scripts to get them to run successfully on the production server?
Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 43
The specified @job_id ('C09EF46A-E6EC-4074-B5F3- A932F5B5B4 95') does not exist.
Msg 14234, Level 16, State 1, Procedure sp_verify_job, Line 203
The specified '@owner_login_name' is invalid (valid values are returned by sp_helplogins [excluding Windows NT groups]).
Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers,
The specified @job_id ('C09EF46A-E6EC-4074-B5F3-
Msg 14234, Level 16, State 1, Procedure sp_verify_job, Line 203
The specified '@owner_login_name' is invalid (valid values are returned by sp_helplogins [excluding Windows NT groups]).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER