Why would you use sql agent? : sql server DBA



Why would you use sql agent? : sql server DBA..

Answer / Rahul G. Momin

SQL Agent is used in SQL Server to automate scheduled tasks such as database backups, job execution, and data movement. It provides a centralized platform for scheduling and monitoring these tasks, helping DBAs maintain the integrity of their databases.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  


How to make a replica of existing oracle server to another server?

3 Answers  


What are the different types of database compression introduced in sql server 2008? : sql server DBA

1 Answers  


What command would you use to encrypt a PL/SQL application?

1 Answers  


. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1 Answers  


Explain the use of table functions.

1 Answers  


what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  


how can you initialize log miner?

1 Answers   Oracle,


What are the recovery models for a database? : sql server DBA

1 Answers  


What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,


deleted of control file how will u recover control file?

4 Answers   CTS,


Categories