What is SQL server agent?
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 |
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?
What is a recursive stored procedure in sql server?
in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Do you know what is rank function?
Tell me in brief how sql server enhances scalability of the database system?
What is measure group, measure? : sql server analysis services, ssas
Can you tell me some of the common replication dmv's and their use? : sql server replication
How can we delete a table in sql server?
How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
Explain ms sql server reporting services vs crystal reports?
How you can change the database name in SQL SERVER?