Share via

Managing Workflow Applications

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

The application owner is responsible for creating an instance of a workflow application on the server and for maintaining the application when it is installed. This involves the following responsibilities:

  • **Creating and removing workflow applications   **Creating instances of applications from templates, and deleting existing workflow applications.

    The application owner can create an instance of a workflow application from a template using the SQL Server Workflow Template Instantiation wizard. The wizard makes it possible for you to select a template, specify the application title, specify database and Web names, and add users to the application database roles. When the wizard is finished, the new workflow-enabled database and Web site are registered, created on the server, and available for use.

  • **Managing templates **  Managing a list of the templates available on the selected server, making it possible to import and export templates, and modifying the properties of a selected template.

    Templates store the information required to create an instance of a workflow application. The template is similar to a snapshot of the workflow-enabled database and Web site. You can use the SQL Server Workflow Template Creation wizard in the Workflow Designer for SQL Server to save an existing application as a new template. Then, use the SQL Server Workflow Template Instantiation wizard to create an instance of the application on another server or SQL Server named instance.

  • **Managing Workflow Application User Directory information   **Configuring the synchronization schedule with Microsoft® Windows® Active Directory and Microsoft® Exchange Server and maintaining user information manually.

    The Workflow Application User Directory contains information about the users who are registered on the server. The User Information tab in the Workflow Manager contains a list of users who can log on to the local SQL Server. This information is available for use in workflow applications. You initially populate the user directory by synchronizing with the Windows Active Directory or Exchange Server directory. Then the information can be edited manually by an administrator or maintained by synchronization.

  • Managing workflow timeout settings   Configuring the Workflow Timeout Job for the selected server.

    The Workflow Timeout Job option, available on the Tools menu, makes it possible for SQL Server system administrators to designate the SQL Server workflow timeout properties. The Timeout Job properties control when Expiry events are processed on the server. For more information regarding the Timeout Job properties, refer to "Job Object (SQL-DMO)" in SQL Server Books Online.

An application owner must have permissions to create new applications on the server, to create and modify SQL Server databases, and to create and modify Microsoft® FrontPage® Web projects on the server. The server owner is responsible for granting the appropriate permissions to application owners.

See Also

Managing the Server | Backing Up and Restoring Workflow Applications | Creating New Applications from Templates | Moving a Workflow Application to a Different Server | Removing a Workflow Application from the Server | Managing Users and Roles | Synchronizing User Information | Editing User Information | Managing Templates