Answer / 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.

What is the difference between Datapump & export/import?

2 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers  

---

How would you go about verifying the network name that the local_listener is currently using?

1 Answers  

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1 Answers   Patni,

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

how can a session indicate its interest in receiving alerts?

1 Answers   Oracle,

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1 Answers  

---

what is the role of dip user in our database?

1 Answers  

---

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1 Answers  

---