Diagnostic and recovery tasks not working

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 running
I ask for your help


June 24th, 2015 1:13am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics