Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select-Sql -TableName DBTable | Out-Html -AsBarGraph
- Start-At -Time "9:00 AM" -Everyday -ScriptBlock {
- Select-Sql -TableName DBTable -ConnectionStringOrSetting SqlConnectionSecretSetting | Select-Object @{Name='DisplayedProperty';Expression={$_.CalculatedValue} | Out-Html -AsBarGraph |New-WebPage -UseJQueryUI | Set-Content $pathToHtmlFile
- }
- sqlchart -D stockdb -P 1433 -servertype mssql -host localhost -e "select * from ohlc where sym='AMZN' AND (date > CURDATE()-60)" -o amazon-candlestick-dark.png --chart candlestick --height 250 --width 730 --theme dark
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement