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.
Friday, April 18, 2008
What is a Scheduled Jobs or What is a Scheduled Tasks?
Labels:
SQL Interview Questions
Subscribe to:
Post Comments (Atom)
Archives
-
▼
2008
(41)
-
▼
April
(21)
- What is De-normalization?
- How to get @@error and @@rowcount at the same time?
- What is Identity?
- What is a Scheduled Jobs or What is a Scheduled Ta...
- What is a table called, if it does not have neithe...
- What is BCP? When does it used?
- How do you load large data to the SQL server datab...
- Can we rewrite subqueries into simple select state...
- Can SQL Servers linked to other servers like Oracle?
- How to know which index a table is using?
- How to copy the tables, schema and views from one ...
- What is Self Join?
- What is Cross Join?
- Which virtual table does a trigger use?
- List few advantages of Stored Procedure.
- What is DataWarehousing?
- What is OLTP(OnLine Transaction Processing)?
- How do SQL server 2000 and XML linked? Can XML be ...
- OPENXML
- What is an execution plan? When would you use it? ...
- Global Temporary Tables
-
▼
April
(21)
No comments:
Post a Comment