job syspolicy_purge_history job fail in sqlserver 2008
hello guys,
when installed sqlserver,it automatically created 1 job name job syspolicy_purge_history.
but failed @ step 1.
the reason is:
date 11/6/2010 2:00:00 am
log job history (syspolicy_purge_history)
step id 1
server mxosv-otsdb01
job name syspolicy_purge_history
step name verify automation enabled.
duration 00:00:00
sql severity 16
sql message id 34022
operator emailed
operator net sent
operator paged
retries attempted 0
message
executed user: nt authority\system. policy automation turned off. [sqlstate 42000] (error 34022). the step failed.
have run statement:
select msdb.dbo.fn_syspolicy_is_automation_enabled
the returned valus 0.
what can resolve it?
or can delete job manually.
thanks in advance.
if haven't things want,be grateful things don't have didn't want.
pradeep adiga
blog: http://www.sqldbadiaries.com
SQL Server > SQL Server Database Engine
Comments
Post a Comment