Solved

How to schedule a process flow?


Userlevel 4
Badge +14

I am trying to simply execute a task, without parameters with a process flow every hour.

 

 

 

 

Indicium Universal (2020.2.2) is running, but I don't see any activity.

The version of IAM is 2020.1 and al hotfixes are done.

 

Could someone explain, step by step, what to do? 

 

icon

Best answer by Mark Jongeling 18 June 2020, 10:13

View original

12 replies

Userlevel 6
Badge +18

Hey Harm,

In the project I'm working on we use the System Flow to execute an import of data on the background so they do work but...

I'm sad to say that the execution of the process action ‘Execute task’ is not yet supported by the System Flow. The supported process actions are all Connectors, and all folder and file related actions like creating, moving and deleting.

The way to run tasks in the System Flow currently is through the use of the process action ‘DB connector’. This connector is supported and is able to run SQL code, for example to execute a stored procedure, on the given Database.

For more information about the DB connector you can check the Documentation: https://docs.thinkwisesoftware.com/docs/sf/process_flows.html#db-connector

Hope it helps you out.

Kind regards,
Mark Jongeling

 

Userlevel 4
Badge +14

Thanks Mark!

This sounds very disappointing to me. I cannot understand, why is it like that? This is one of the most basic scenarios.

I will try to use the DB connector but I don't like this because I don't want to store DB credentials in the end database especially as I mostly work with Azure databases.

BR,

Harm

 

 

 

 

 

Userlevel 6
Badge +18

I understand the troubles with that. Last I heard is that Product Innovation is working hard to realize all process actions that don’t require user input for the System Flow. It's certainly on their radar.

Good luck Harm!

Kind regards,
Mark Jongeling

Userlevel 4
Badge +3

Just to be sure: this means that when you want to run a task on a regular basis, the only option is to use the connector? Or is there another way to run scheduled tasks? I'm also trying to get this to work.

Userlevel 5
Badge +15

I understand the troubles with that. Last I heard is that Product Innovation is working hard to realize all process actions that don’t require user input for the System Flow. It's certainly on their radar.

Good luck Harm!

Kind regards,
Mark Jongeling

Hi,

Do you know if there are any update on this? I'm also trying something with just simply executing a task (stored procedure) every minute or so.

I do have a very obscure work around for this 🤨. I’ve created a process flow which only executes a http connector (a dummy call to google.com i.e.) and then I’ve attached a control procedure to the http connector (of type processes). I've scheduled this call every minute, and because the proces sql code is called, I can execute sql code scheduled.

Userlevel 6
Badge +18

Hi,

Do you know if there are any update on this? I'm also trying something with just simply executing a task (stored procedure) every minute or so.

I do have a very obscure work around for this 🤨. I’ve created a process flow which only executes a http connector (a dummy call to google.com i.e.) and then I’ve attached a control procedure to the http connector (of type processes). I've scheduled this call every minute, and because the proces sql code is called, I can execute sql code scheduled.

Hi René,

As far as I know they are working on supporting a couple more process actions with the next release of the Thinkwise Suite. I did hear that using the Database connector will be more convenient but we will see when they share the new features and developments.

For my project, we using Database connectors to execute procedures since in the SQL code field of the DB connector we can specify the query. Your solution is also a viable one. We use the Convert JSON to XML process action for creating the connection string needed for the DB connector since we use JSON string text to give parameters and values to the DB connector. The benefit of that is that converting JSON will always work, while theoretically a http connector call to google.com could give an error when google.com doesn’t respond. But I'm very glad google.com virtually always is available :wink:

Userlevel 3
Badge +5

I'm currently trying to implement my first scheduled process and had several Execute Task-actions in mind. In https://docs.thinkwisesoftware.com/docs/sf/process_flows.html#process-schedules I see that Decisions are also supported for scheduling. Since a decision is about the same as an Execute task, I'll put my code inside a Decision.

If anyone knows a reason why this would not work, please let me know why.

Userlevel 6
Badge +18

I'm currently trying to implement my first scheduled process and had several Execute Task-actions in mind. In https://docs.thinkwisesoftware.com/docs/sf/process_flows.html#process-schedules I see that Decisions are also supported for scheduling. Since a decision is about the same as an Execute task, I'll put my code inside a Decision.

If anyone knows a reason why this would not work, please let me know why.

Hi Roy,

Since the 2020.2.8 version of the Indicium (Universal) the Decision node should function inside a System Flow. Edit: So the decision node is a good alternative yes. Also the Application connector can be used for this.

Kind regards,
Mark Jongeling

Userlevel 5
Badge +9

@Roy van Uffelen  please take the following in mind when using a decision node: "A decision node does not perform an actual action. Because of this, no input and output is available.”. If you don't need output then this should work. If you do need output then for the time being the application or database connector is the way to go. 

Userlevel 3
Badge +5

@Erwin Ekkel The program object behind a decision does have input-output parameters for all process variables and for each process step leaving the decision. Changes made to the process variables are available for other process actions that follow this decision.

In this way it is possible for a decision to actually perform an activity. I have not tried to insert/update/delete records through a decision, but retrieving information and updating the the process variables is something I have done, and thus is possible. If this is a bug I'm glad it is there and hope it remains.
I did notice that monitoring the process flow is not as informative as using tasks. That is something that could be improved upon.

Userlevel 6
Badge +18

To verify, the Decision process action does not have Input and Output parameters (Erwin was mentioning the Input and Output tab in the Process flow screen) but yes, the Process procedure does have all the process flow variables available.

That way you can execute any code you would want to in that Process procedure such as reading, using and setting process variables. Yes, insert/update/delete/etc. is all possible.

Monitoring this process action will not result in much information as it doesn’t do anything by itself. It solely executes a process procedure in which a decision can be made :wink: 

Userlevel 1

Hey,
stumbled upon this topic doing research for a system flow that needs to execute a task.
If I am not mistaken we can now use task's in our system flows by using the process action
“execute system task”.
Wanted to put that answer here for future people.

Reply