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

Question

Amit Singh · Answer

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.

interview

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

Amit Singh

Can you answer this question?

1 Answers

Liked By