[AZABAZA]

По MS SQL во тут есть кое что, но там показывает все базы а надо отдельные базы

[Kazun]

Для MSSQL:

1) Статус по Backup, функция SQL
http://beyondrelational.com/modules/...us-script.aspx

2) Invoke-Sqlcmd2
https://gallery.technet.microsoft.co...a-433cc4e30894

Код:

$query = @'
	Пункт 1
'@

$body = Invoke-Sqlcmd2 -ServerInstance "dserver\test" -Query $query | ConvertTo-Html | Out-String
Send-MailMessage -to "User01 <user01@example.com>" -from "User02 <user02@example.com>" -subject "Test mail" -body $body -BodyAsHtml

Еще альтернативное решение для MS SQL - http://blogs.technet.com/b/heyscript...up-status.aspx

[AZABAZA]

Kazun,

2-ой пункт куда прописать?

Если просто закинуть до $body то отваливается ошибка

Код:

Exception calling "Open" with "0" argument(s): "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not fou
nd or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error:
 26 - Error Locating Server/Instance Specified)"
At line:104 char:15
+     $conn.Open <<<< () 
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException
 
Exception calling "Fill" with "1" argument(s): "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not fou
nd or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error:
 26 - Error Locating Server/Instance Specified)"
At line:109 char:19
+     [void]$da.fill <<<< ($ds) 
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

[Kazun]

Проблема подключения к SQL Instance - о чем и уведомляют.