What is SQL server agent?
- 2 Answers
- 8848 Views
- HCL, SAP Labs, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / sabin
Managing all scheduled jobs, monitoring for alerts and
notifying operators
| Is This Answer Correct ? | 8 Yes | 0 No |
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
WHAT IS UNIQUE IDENTIFIER DATA TYPE?
Differentiate between a local and a global temporary table?
How do I clean up sql server transaction log?
is there a column to which a default can't be bound? : Sql server database administration
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What is dimension table? : sql server analysis services, ssas
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What are commonly used mssql functions in php?
How to generate random numbers with the rand() function in ms sql server?
How to use union to merge outputs from two queries together in ms sql server?
What is the most common type of join?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
