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
how can a database be repaired? : Sql server administration
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What is a collation in ms sql server?
How do I run a trace in sql server?
Tell me the phases a transaction has to undergo?
What languages bi uses to achieve the goal?
What is the purpose of data source?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
How does stuff differ from the replace function?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
What is the difference between sdf and mdf?
What is collation sensitivity?
plss anybody specify tha constrian management system in dbms
What is sqlservr.exe - process - sql server (sqlex?press)?
What is the full meaning of dml?