O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

What Are Workflow and Batch Processing?

Workflow is defined as executing a series of steps (that is, work) and having the ability to take different paths (that is, actions) based on the outcome of the steps. Workflow processing contains three important elements called the three S's. The three S's are

  • Status— Where is the process now?

  • Stages— Where has it been?

  • State— Where is it going?

Essentially, the three S's describe the key elements that make up workflow processing. To build workflow into a process, the process needs to maintain a status so that we can determine what the task is currently doing. To have workflow, you must have more than one stage (that is, step) that the process is to execute. As a process (that is, task) completes, the workflow ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required