WHAT DO “JOBS” AND “ALERTS” MEAN IN SQL SERVER ?

Amit Singh

Total Post:565

Points:2825
Posted by  Amit Singh
 1360  View(s)
Ratings:
Rate this:
  1. Amit Singh

    Post:565

    Points:2825
    What do “jobs” and “alerts” mean in SQL Server ?

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!