What is SQL server agent?

Answers were Sorted based on User's Feedback



What is SQL server agent?..

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

Is This Answer Correct ?    11 Yes 1 No

What is SQL server agent?..

Answer / sabin

Managing all scheduled jobs, monitoring for alerts and
notifying operators

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Does a specific recovery model need to be used for a replicated database? : sql server replication

0 Answers  


Differentiate between a having clause and a where clause.

0 Answers  


What is the difference between delete and truncate statements?

0 Answers  


How do use Having,Group by,Group function in SQL?

0 Answers  


What is log ldf?

0 Answers  






What is nolock hint in sql server 2008

0 Answers   HCL,


Do you know what are the reporting services components?

0 Answers  


How to insert data into an existing table?

0 Answers  


What are commonly used mssql functions in php?

0 Answers  


What is single-user mode?

0 Answers  


what exactly sql injuction.how to overcome.....

0 Answers   CTS, IBM,


How to insert stored procedure result into temporary table?

0 Answers  


Categories