Answer / renu

SQL Server Agent is a Microsoft Windows Service that
executes scheduled administrative tasks called jobs.

It is made up of 3 components :

1)Jobs - Scheduled tasks

2)Alerts - set of actions occur when an event occurs.

3)Operators -People who alerts are sent to

Answer / sabin

Managing all scheduled jobs, monitoring for alerts and
notifying operators

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

---

What are the different types of stored procedures?

0 Answers  

---

what is checksum in sql server.........???

0 Answers   TCS,

---

Do you know what are the reporting services components?

0 Answers  

---

Does group by or order by come first?

0 Answers  

---

---

How do database indexes work?

0 Answers  

---

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---

How to delete existing triggers using "drop trigger"?

0 Answers  

---

Can we call SP inside a query?

5 Answers   CA, CarrizalSoft Technologies, Wipro,

---

How can I check that whether automatic statistic update is enabled or not?

0 Answers  

---

What is difference between equi join and inner join?

0 Answers  

---

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

---