Answer / subramaniam

sql job is scheduling the work into server and it will
automatically run and finish the job
for this we have to set the time.
what is the use of the job is
1) it check the database automatically
2)take a back up of database

for this job we have to start the Sqlserver agent and
give the date and time for this particular job

what are defaults? : Sql server database administration

0 Answers  

---

How to know whether our backup is succesfully taken?

1 Answers  

---

What is a partition key?

0 Answers  

---

What are the pros and cons of creating extended stored procedures?

1 Answers  

---

What is triggers in ms sql server?

0 Answers  

---

what is the difference between procedure and function.

4 Answers   Thomson,

---

What are system databases in ms sql server?

0 Answers  

---

what is normalization? what is denormalization?

9 Answers   Satyam,

---

How can you tell if a database object is invalid?

0 Answers   MCN Solutions,

---

Can we create nonclustered index in a table without creating a clustered index

1 Answers  

---

Difference between report and query parameter. Why do we need different type of parameter?

0 Answers  

---

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

3 Answers   C3I, eSoft, iPRO Solutions, Wipro,

---