Powershell, WMIC and remote execution in Tidal

[Marc Clasby]

Anyone else leveraging these tools to remotely execute against application/database tiers? We are perfroming basic activities - stop/start service, remote batch file execution, file operational activities. We are trying to simplify our toolsets but in addtion make them more powerful and extend the usabiliuty of tidal in our enterprise. I am wondering what other creative things people have done?

Marc

[Marc Clasby]

Here's a little more advance technique we put together.. a little trick to do a dynamic varset with powershell w/ API

we detect a file then count the file rows, we then do some math, round the result and set that integer into a number variable (global) this is then used as the seconds in a downstream "sleep" job to dynamically postpone retrieving a return file giving the vendor time to process it through their system and return a file to us.

Job details

CMD POWESHELL

PARAMS

$trans = Get-Content '\\gmo\dev\app\tidal\test\Confirmation.csv';

$FTP_SleepTime =  [Math]::Round($trans.Count * .01  );

Write-Host Sleep time should be a round number $FS_SleeptTime;

invoke-command -scriptblock {d:\TIDAL\Scheduler\Client\sacmd.exe varset -n FLAG_FTPSleepTime -v $FTP_SleepTime}

Environment

POWERSHELL 2.0 on Windows Server 2008 O/S

Tidal Client installed locally  on Agent D:\ drive with it's default alias pointing to it's opwn database environment

Client ver 5.3.1.317

Agent ver 3.0.1.14

Master ver 5.3.1.318