Disconnect
AutomatR.MSSQLDataBase.Database.Disconnect
The "Disconnect" activity in AutomatR for SQL Server databases allows you to disconnect from a specified database. This activity is crucial for releasing resources and closing the connection to the database.
Properties
| Name | Description |
|---|---|
| Input | |
| Connection | Enter the database connection variable used for disconnecting the database connection. |
| Misc | |
| DisplayName | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Disconnect" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Ex.: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
How to use:
- Drag and drop the "Disconnect" activity onto the workflow.
- Configure the properties by specifying the database connection variable used for disconnecting.
- Optionally, configure the delay for synchronization purposes.
- Execute the workflow to disconnect from the specified database.
Example: Consider an example where the "Disconnect" activity is used to disconnect from a SQL Server database:
Disconnect:
Connection: SqlConnectionVariable
In this example, the "Disconnect" activity disconnects from the SQL Server database using the SqlConnection variable "SqlConnectionVariable." The disconnection process is executed successfully.