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 you append an identity column to a temporary table?
Delete duplicate rows without using rowid.
How to recreate an existing index in ms sql server?
Explain what is lock escalation?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is the difference between truncate and delete commands?
What is store procedure? When do you use?
Differentiate between truncate vs delete in mssql?
Describe how to use linked server?
What are the ways available in sql server to execute sql statements?
Explain Capacity planning to create a database? and how to monitor it?
What is default constraint?
Your table has a large character field there are queries that use this field in their search clause what should you do?
How to find the service pack installed? : sql server database administration
What is difference between createstatement and preparedstatement?
