What is SQL server agent?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why truncate is ddl?

605


Explain iaas, paas and saas?

74


Explain datetimeoffset data type in sal server 2008?

531


What is report server project?

106


what is denormalization and when would you go for it? : Sql server database administration

697






What is default port number for sql server 2000?

590


What is an example of a foreign key?

507


How are the exceptions handled in sql server programming?

603


What is dynamic cursor in SQL SERVER?

559


Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

607


What are the different types of sql server replication? : sql server replication

622


Explain view in sql server?

615


What are the features of Embedded SQL

664


What are the restrictions that views have to follow? : SQL Server Architecture

527


Explain the microsoft sql server delete command? : SQL Server Architecture

575