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

Posted by

To view Verified answers click on the button below.

Scheduled tasks let user automate processes that run on regular or predictable cycles. User
can schedule administrative tasks, such as cube processing, to run 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.