Home > DeveloperSection > Interviews > What do “jobs” and “alerts” mean in SQL Server ?

Posted on    March-28-2011 9:06 AM

 MSSQL Server MSSQL Server 
Ratings:
 1 Answer(s)
  1213  View(s)
Rate this:

Amit Singh

Total Post:565

Points:2825
Posted on    March-28-2011 12:00 AM

Jobs: Using SQL Server Agent you can create and schedule jobs that automate routine administrative tasks. Database administrators create jobs to perform predictable administrative functions either according to a schedule or in response of events and conditions. Jobs can be simple operations containing only a single job step or can be extremely complex operations containing many job steps. SQL Server Agent is responsible for management and execution of all jobs. Agent must be running for jobs to be executed. SQL server 2k supports jobs containing operating system commands.
Alerts: database administrators define alerts to provide event and performance condition notification and to execute jobs in response to SQL server events or performance conditions. E.g. when the log is 90% full an alert can be configured to fire a job that executes a job to back up and truncate the transaction log.

Don't want to miss updates? Please click the below button!

Follow MindStick