I have A,B,C servers.i want to 3 servers jobs move to D
server(target server)..how?
note: i said that take the backup of msdb and restore to the
target server..he said while restoring jobs replaced.
what is the solution
- 1 Answers
- 2189 Views
- I also Faced
- E-Mail Answers
Answer Posted / Mohit Singhal
To move SQL Server Agent Jobs from one server (A, B, or C) to another server (D), you can follow these steps:
1. Backup the msdb database from the source server using T-SQL commands or SQL Server Management Studio.
2. Restore the backup on the target server (D).
3. After restoring the msdb database, the jobs will be present in the target server's msdb database but not yet operational.
4. To make the jobs functional, you need to register the jobs on the target server using T-SQL commands or SQL Server Management Studio.
5. To register the jobs, run the following command for each job:ntsp_add_job @job_name = 'JobName', @step_name = 'StepName' ...
6. After registering the jobs, you can enable them and schedule them as needed.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
