Solved

How to schedule a process flow?

  • 18 June 2020
  • 6 replies
  • 74 views

Userlevel 6
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

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

 

View original

6 replies

Userlevel 4
Badge +15

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 6
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 4
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

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 4
Badge +11

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 4
Badge +15

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:

Reply