WMI 拒绝访问 解决方法之二
摘要:1) Make sure that the scanning account is an administrator on the target computer.2) Make sure that the scanning account's password is not expired.3) Check the DCom Security settings. This script can configure the necessary DCOM and windows firewall settings: download scriptAccess Permissions: E
阅读全文
posted @
2011-10-13 16:20
永无止境
阅读(2154)
推荐(0)
SqlServer 查询作业执行持续时间
摘要:select job_name, run_datetime,SUBSTRING(run_duration, 1, 2) + ':' + SUBSTRING(run_duration, 3, 2) + ':' +SUBSTRING(run_duration, 5, 2) AS run_durationfrom(select job_name, DATEADD(hh, -7, run_datetime) as run_datetime, run_duration = RIGHT('000000' + CONVERT(varchar(6), h.run
阅读全文
posted @
2011-10-10 10:46
永无止境
阅读(798)
推荐(0)