What is Job in Sql Server ?

 Posted by Rajkatie on 6/23/2012 | Category: Sql Server Interview questions | Views: 24018 | Points: 40
Answer:

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


Source: MSDN | Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response