Answer Posted / shiva

After we have verified that STATSPACK is installed and working, we can schedule automatic data collection. By using the statsauto.sql script we can automatically schedule an hourly data collection for STATSPACK. The statsauto.sql script contains the following directive:

SQL> execute dbms_job.submit(:jobno, 'statspack.snap;',
trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno);

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

2113

---

How to start SQL Server in minimal configuration mode?

7973

---

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

2620

---

how can you process messages in order asynchronously?

976

---

internal architecture

2196

---

How can you control the amount of free space in your index pages? : sql server DBA

1314

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1081

---

What is transparent data encryption? : sql server DBA

1194

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1006

---

how to restore files with rman?

2304

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1069

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

2231

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1111

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2203

---

What is the difference between clustered and non-clustered index? : sql server DBA

1091

---