Batch processors

[Pierre-andre]

Hi,

I would like to create a batch processor to backup my database everyday at 22:00.

I use the Scheduler plugin with this code:

Code: Select all

plugins.scheduler.addCronJob(jobname, "* 00 22 * * ?", globals.Backup_DB,startDate,endDate,args)


When I strat this method from client, it's work well but when I shutdown the client, this process is remove automatically.

How can I make a batch process which call a global method every day at 22:00 when all clients are close.

Thanks

[IT2Be]

You can start a batch processor on the Servoy server. This is a (headless) client running on that machine. See documentation and web admin pages.

BTW why don't you perform a backup through the db tools of your database?

[Pierre-andre]

Because I've a form on Servoy where I change easily the frequency of backup.

With cronTimings I think it easy and I don't know postgres rather well to do that with tool.

[IT2Be]

OK, I understand.

Well in that case you could use the batch processor.

[Pierre-andre]

Thanks It's work fine

[IT2Be]

The only thing you need to know/realize that this 'eats' one client license!

[ROCLASI]

Hi Pierre-andre,

Why use a Servoy cronjob to schedule a database backup when you can do it all on the server itself?
I assume you use pg_dump/pg_dumpall for the backup. Depending on the OS you are using you can setup a server cronjob to trigger this.
What OS are you using ?

[IT2Be]

Hi Robert, I asked almost the same question with the following reply

Because I've a form on Servoy where I change easily the frequency of backup.

With cronTimings I think it easy and I don't know postgres rather well to do that with tool.

[ROCLASI]

Hi Robert, I asked almost the same question with the following reply

Because I've a form on Servoy where I change easily the frequency of backup.

With cronTimings I think it easy and I don't know postgres rather well to do that with tool.

Ah!
But how do you access the form in a batchprocessor?
An option would be to make it data(base) driven but that does mean you have to let it remove the current (Servoy) cronjob and load the new one.
I think a cronjob on the server is easier to change.

[IT2Be]

An option would be to make it data(base) driven but that does mean you have to let it remove the current (Servoy) cronjob and load the new one.

Excactly what I thought of. Starting and stopping the cronjob is very easy because you already know the name.

I don't really agree it is necessarily easier to create a cronjob on the server. that depends on rights that you want/can give to the user that is allowed to change these settings.
I do agree in general that it would be easier/more flexible/more controllable to let the appropriate db tools do the job.

[pbakker]

But how do you access the form in a batchprocessor?

A batchprocessor is a full client, so you should have no problem whatsoever accessing the form...

[ROCLASI]

But how do you access the form in a batchprocessor?

A batchprocessor is a full client, so you should have no problem whatsoever accessing the form...

Erm...it's a headless client. How would you want to access the form as a human?

[pbakker]

Ehum... You just use a solution as batchprocessor... you can also open the same solution as a client and alter the settings for the schedule by going to the form.

As I understand it, he wants to have scheduled processes and through a GUI he created be able to edit their schedule.

Paul

[IT2Be]

- create a table with preferences
- create a form for the user to access the table

That is how I created settings for a batch processor.

[ROCLASI]

Ehum... You just use a solution as batchprocessor... you can also open the same solution as a client and alter the settings for the schedule by going to the form.

As I understand it, he wants to have scheduled processes and through a GUI he created be able to edit their schedule.

Paul

I stand corrected.