What is Job in Sql Server ?
Interview question and answer by: Rajkatie
| Posted on: 6/23/2012 | Category: SQL Server Interview questions
| Views: 1535 | | Points: 40
It is a series of operations performed by SQL Server Agent sequentially .
It can do a wide range of activities, including running T-SQL scripts and ActiveX scripts, Integration Services packages, Analysis Services commands and queries, or Replication tasks.
Jobs can run repetitive or schedulable tasks, and they can automatically notify users of job status by generating alerts, thereby greatly simplifying SQL Server admin.
A job can be edited only by its owner or members of the sysadmin role
MSDN | Asked In:
| Alert Moderator
Found interesting? Add this to: