Interested to Buy Any Domain ? << Click Here >> for more details...
What is SQL server agent?
- 2 Answers
- 9963 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 |
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
Which table keeps information about stored procedures?
Describe in brief databases and sql server databases architecture.
How can you start sql server in different modes?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What is normalization? Describe its different types.
What is the difference between count () and rowcount ()?
Define synonym?
How does clustered and non clustered index work?
What is the difference between NOROW and LOCKROW?
0 Answers Accenture, Honeywell, Satyam,
can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?
Describe in brief sql server monitoring ways.
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
