cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2195
Views
0
Helpful
1
Replies

Powershell, WMIC and remote execution in Tidal

Marc Clasby
Beginner
Beginner

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

1 Reply 1

Marc Clasby
Beginner
Beginner

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

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: