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 is partition in sql server?

543


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1381


What is the purpose of grouping data in a report?

551


List out the differences between global and local temp tables in sql server?

584


What is the full form of dql?

524






How to generate random numbers with the rand() function in ms sql server?

575


What languages bi uses to achieve the goal?

519


Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

543


How many tables can be joined in SQL Server?

598


what are triggers? : Sql server database administration

514


What are the different types of backups that exist?

691


What are joins in sql and what are the different types of joins?

562


Explain what is dbcc?

603


Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

555


What is store procedure?

656