hallo
i have scom 2012 r2 .
i get alert for my sql
Source: WRW
Path: sqlserver.mydomain.com
Alert: MSSQL 2014: DB Average Wait Time is too high
Closed
The Average Wait Time of SQL instance "WRW" on computer "sqlserver.mydomain.com" is too high. See "Alert Context" tab for more
details.
Last modified by: System
I want to run Diagnostic and recovery tasks
i crate bat file :lock.bat
This is what is listed in the file:
sqlcmd -S sqlserver\WRW -i C:\scripts\LOCKS\ShowLOCKS_WRW.sql -o C:\scripts\LOCKS\lock_list.txt
When I run these commands in Cmd or PowerShell it works right.
The problem that when I set it in the Diagnostic and recovery tasks on the warning I mentioned -It's not runningI ask for your help