What is Use of Advanced Work Flow Screen?
Work Flow screen helps user to Create, Configure and Run the Built-in and Custom Tasks.
How to give permission for WorkFlow task
Go to Menu bar -->File --> User Authorization --> WorkFlow tab.
Click on Add button, add popup will appear.
Click on Search Icon, WorkFlow Task Select window will appear.
Select the required task and click on Select button.
Select the required task.
Give the View permission and add the task.
The SQL Server Execute SQL and SQL Server Execute Procedure tasks are the Custom tasks
The SQL Server Execute SQL task is used to run custom queries, and the SQL Server Execute Procedure task is used to execute custom procedures.
How to Add Tasks in Work Flow?
Go to the Menu bar → File → Workflow. The Empty Advanced Workflow screen will be displayed, where the user can add Workflow tasks from the selection window.
Click on Add Icon, Add popup will appear.
Click on Search Icon, WorkFlow Task Select window will appear.
Select the required task and click on Select button.
Select the task to add it to the task type, enter the required fields (Description, Affected Module), and click the Add button.
The selected Task added to the workflow screen.
How to Add Group Task and Child Task in Work Flow?
User can Add multiple Tasks(Child) under one Group Task.
Add Group Task
Click in Add icon and select the search icon to select the GroupTask.
Add Child Task
Step:1
Right click on group task and click on Add child option, add popup will appear, select the required task, and add to Group
Step:2
Right click on required task , select the add to group , task will added to group .
If run the group task , all tasks which tasks are inside that group will run.
How to Run the WorkFlow tasks Manually
Go to the Workflow screen, select the task by clicking the checkbox, and then click the Run button. The task will execute and display the result as either 'Success' or 'Failure'. If the task is showing as 'Pending', check the 'Task Manager and Scheduler' connection, and the 'Database' connection in System Admin.
How to Run the WorkFlow task Automatically
· User can Run the Task Automatically at scheduled time which can set in Schedule cron Parameters.
· Automated Tasks will be Run in WorkFlow Queue.
· Right click on the Task which has to be scheduled for Run and select details.
Click on Edit and enter the schedule time and save it , selected task will automatically run for sechuled Cron time.
The cron expression is made of five fields. Each Field can have Following values
Based on the above, the scheduled task will run once every minute.
Example
For more details Refer this https://crontab.cronhub.io/
User can check when the Task is scheduled to Run under ‘Next Run On’ column and also user can check the Task Last Run details Under 'Last Run On' Column, also User can check the log in System Admin 'Task Manager and Task Scheduler'.
User can check the TaskManger and Scheduler connection in system admin screen.
