• Awadhendra Tiwari
Posted Date
5/11/2011
|
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.
|
|