Re^2: Scheduling Perl Tasks

Hi Dave,

What if I can manage that same script does not runs in parallel will perl scritps accessing separate excel files can also cause any issue?? I also used Win32::OLE module for many scripts.

Comment on Re^2: Scheduling Perl Tasks

Replies are listed 'Best First'.
Re^3: Scheduling Perl Tasks by davido (Cardinal) on Mar 23, 2017 at 14:38 UTC
So you now are ok with the same script running as long as it's acting on different files? Then yes, that's just fine. Use flock, as discussed in the slides I linked to, to lock the files you are acting upon. That will ensure that multiple instances of your script cannot possibly touch the same file. If you do that, sure, there's nothing wrong with running the same script multiple times simultaneously against different data sets, so long as none of the instances attempt to write to the same file. Dave	[reply]

Replies are listed 'Best First'.

Re^3: Scheduling Perl Tasks
by davido (Cardinal) on Mar 23, 2017 at 14:38 UTC

So you now are ok with the same script running as long as it's acting on different files? Then yes, that's just fine. Use flock, as discussed in the slides I linked to, to lock the files you are acting upon. That will ensure that multiple instances of your script cannot possibly touch the same file. If you do that, sure, there's nothing wrong with running the same script multiple times simultaneously against different data sets, so long as none of the instances attempt to write to the same file.

Dave

[reply]