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

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  


What is a recursive stored procedure in sql server?

0 Answers  


in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 Answers  


Do you know what is rank function?

0 Answers  


Tell me in brief how sql server enhances scalability of the database system?

0 Answers  






What is measure group, measure? : sql server analysis services, ssas

0 Answers  


Can you tell me some of the common replication dmv's and their use? : sql server replication

0 Answers  


How can we delete a table in sql server?

0 Answers  


How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 Answers  


What is log shipping? Can we do logshipping with SQL Server 7.0 ?

0 Answers   IBM,


Explain ms sql server reporting services vs crystal reports?

0 Answers  


How you can change the database name in SQL SERVER?

0 Answers  


Categories