[Info-ingres] Windows Server and batch scripts

[Martin Bowes]

Hi Paul,

I've managed to look through those scripts...it looks like PowerShell doesn't do subroutines and you've had to make them using goto statements. Is that the case?

Also, is postie.exe a home brew effort?

Marty

-----Original Message-----
From: Paul White [mailto:paul.white at shift7solutions.com.au] 
Sent: 27 July 2017 11:06
To: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Windows Server and batch scripts

"it's more powerful than cron"
and comes with some really annoying bugs.


I've attached some examples I've used and enhanced over the years.
Feel free to borrow or reuse - no warranty implied.



-----Original Message-----
From: info-ingres-bounces at lists.planetingres.org
[mailto:info-ingres-bounces at lists.planetingres.org] On Behalf Of Roy Hann
Sent: Thursday, 27 July 2017 7:11 PM
To: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Windows Server and batch scripts

Martin Bowes wrote:

> Much to my horror I've had to install a server on a windows 
> box....Ugh, I feel unclean.
> 
> How do you automate batch scripts to do basic maintenance such as 
> backups, modifies and optimizes? If anyone has a sample script and 
> some pointers on what the cron equivalent is on Micropox then I'd be 
> very grateful to see them.
> 
> Martin Bowes
 
As Michael Cressy pointed out, the Windows Task Scheduler is what you need. As he also said, it's more powerful than cron.

What he didn't say is that it can be a royal pain to diagnose and debug when something goes wrong. It's idea of success is doing its own job successfully, not your script doing its job successfully. "The operation was a complete success. Unfortunately the patient died."

Working across multiple platforms I would not counsel you to invest any time in learning PowerShell. It is undoubtedly capable. It is vastly more capable than the DOS scripting language. But the learning curve is steep and long and you end up with a skill that is applicable only to Windows.

I have become a bit of a fan-boy for Python (Python 3.5 to be specific), which I now use for all my platform-independent scripting. 



_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
http://lists.planetingres.org/mailman/listinfo/info-ingres