What is sql server agent, Database Management System

What is SQL Server Agent?

SQL Server agent plays a significant role in the day-to-day tasks of a database administrator (DBA). It is often overlooked as one of the major tools for SQL Server management. Its purpose is to ease the execution of tasks for the DBA, with its full- function scheduling engine, which permits you to schedule your own jobs and scripts.

 

Posted Date: 7/10/2013 6:20:45 AM | Location : United States







Related Discussions:- What is sql server agent, Assignment Help, Ask Question on What is sql server agent, Get Answer, Expert's Help, What is sql server agent Discussions

Write discussion on What is sql server agent
Your posts are moderated
Related Questions
Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is: If R has m tuples and S has n tuples then maximum siz

Define Join and Outer Join and differentiate between them.      Ans: Join - It generates all the combinations of tuples from two relations which satisfy a join condition.  Oute

Which method is used to key transformation ? A hash method is used to key transformation.

Which database level is closest to the users? External database level is closest to the users.


crete a data base relationship model Entity: Students; Professors; Dormitories buildings; Attributes of students: Name; Address; Dorm;

2NF Normal Form : A relation schema process R is in 2NF if it is in 1NF and each non-prime attribute A in R is fully functionally related on primary key. Second normal form (2N

Define DBA database administrator? DBA : A database administrator (DBA) is a person who is responsible for the environmental aspects of a database. In common, these involves:

Multilevel Index The Multilevel Index is a modification of the secondary level index system. In this system we might be use even more number of levels in case the table is eve

What is called as recursive partitioning? The system repeats the splitting of the input unless each partition of the build input fits in the memory. Such partitioning is known