What is a job?

Answer Posted / sudhir kumar pal

Don't post rubbish Answer

Jobs : A job is a specified series of operations performed
sequentially by SQL Server Agent.
A job can perform a wide range of activities, including
running Transact-SQL scripts, command prompt applications,
Microsoft 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
administration.


More Information Click This Link


http://msdn.microsoft.com/en-us/library/ms186273.aspx

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the dis_advantages of stored procedures, triggers, indexes?

1682


How to create function without parameter in sql server?

557


What are the dmvs?

562


When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

572


What is the difference between truncate and delete commands?

561






What are views used for?

617


Write an SQL query to obtain the 2nd highest salary.

604


Can truncate be rolled back?

535


How do you start single user mode in clustered installations?

515


what are acid properties? : Sql server database administration

488


Tell me about builtinadministrator?

560


How and why use sql server?

539


Define synonym?

726


what is a transaction and what are acid properties? : Sql server database administration

522


What are the different ways you can create databases in sql server?

567