What is a Scheduled Jobs or What is a Scheduled Tasks?

What is a Scheduled Jobs or What is a Scheduled Tasks?

Scheduled tasks is the bassically use of the completing task which is schededule by any user who use the system administrator, let user automate processes that run on regular or predictable cycles. user can decide his task for the perticule schedule time such as cube prossessing, for running the  during times of slow business activity. User can also determine the order in which tasks run by creating job steps within a SQL Server Agent job. E.g. back up database, Update Stats of Tables. Job steps give user control over flow of execution. If one job fails, user can configure SQL Server Agent to continue to run the remaining tasks or to stop execution.

By:UMANG
Date:2012-01-09 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher