Viewing 7 posts - 1 through 7 (of 7 total)
But I have many tables, many querys, this is only a short part of code, the code have more than 450 lines, I need to do a report, I belive...
June 15, 2022 at 1:29 pm
I need to use a variable because I have to do many things before send a message, follow part of code:
DECLARE @saida VARCHAR(MAX), @MSG VARCHAR(MAX)
SET @saida...
June 15, 2022 at 12:37 pm
I found this Sources from: https://solutioncenter.apexsql.com/multi-server-script-to-automatically-monitor-sql-server-availability/
I run this script in power shell
February 7, 2020 at 12:44 pm
Thank you so much. I change all columns size. It's solved.
February 6, 2020 at 2:16 pm
I will check if there is a column on tbl_serveravailability which is not wide enough to accept the data which is being inserted into it.
February 6, 2020 at 1:55 pm
How to solve this problem ?
February 6, 2020 at 1:43 pm
Function Get-ServiceInfo {
Param(
[String]$Server,
[String]$SQLInstance,
[String]$SQLService,
[String]$SMTP,
[String]$To
)
# Get the current datetime
$logdate = (Get-Date).ToString('MM/dd/yyyy hh:mm:ss')
#Function created to send email
Function sendEmail
{
param($from,$to,$subject,$smtp,$body)
[string]$receipients="$to"
$body = $body
$body = New-Object System.Net.Mail.MailMessage $from, $receipients, $subject, $body
$smtpServer = $smtp
$smtp = new-object Net.Mail.SmtpClient($smtpServer)
$smtp.Send($body)
}
#Test the...
February 6, 2020 at 1:42 pm
Viewing 7 posts - 1 through 7 (of 7 total)