Search

Database Automation with Polling

Articles

The following sample task is created using the Polling Nodes and Database Node to automate the process of executing a database node continuously until it is stopped manually from the Task Execution screen. Here, the task keeps executing continuously until it is stopped manually from the Task Execution screen.

  1. In the Task Design screen, click on the << icon present on the right-hand side toolbar to expand the Nodes section.
  2. Drag and drop the Start Polling, Database and End Polling nodes respectively from the Nodes section and align them in the following order: Image description

    Make sure that the Task Design screen is in Edit mode (the Edit button is highlighted in green colour).

  3. Double-click on the Start Polling node and specify the porperties. Image description
  4. Double-click on the Database node.
  5. Select any existing configuration if it matches the criteria of the user or create a new configuration. Refer to Setting up Database Configuration section for more details.
  6. Click on the Query tab and provide the required details. Image description
  7. Click on the Properties tab and provide the required details. Image description
  8. Double-click on the End Polling node and specify the porperties. Image description
  9. Click on the Close icon and then on the Save icon.
  10. Make sure the Execution Bot is running. Refer Start/Stop Procedure.
  11. To execute the task, navigate to the Run Task screen.
  12. Click on the Run icon to execute the task. Image description
  13. To observe the execution, navigate to the Execution History screen.
  14. Click on the Run ID to view the Execution Details of the task. Image description
  15. To stop the execution of the task, do either of the following:
    1. Click on the Stop Run button on the Execution Details screen. Image description
    2. On the Execution History screen, click on the Stop icon. Image description
      1. Click on the STOP AFTER CURRENT NODE button to stop the execution of the task after the current node being executed finishes its execution
      2. Click on the STOP IMMEDIATELY button to stop the execution abruptly. Image description
Did you find what you were looking for?