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.

as ivan mentioned, syspolicy_purge_history job failing because policy management disabled on instance. may enable policy management using ssms --> management --> right click policy management --> select enable. once policy management enabled, job complete successfully. more job here


pradeep adiga
blog: http://www.sqldbadiaries.com

recent posts on blog


SQL Server  >  SQL Server Database Engine



Comments

Popular posts from this blog

Azure DocumentDB Owner resource does not exist

Trying to register with public marketplace error with 'Get-AzureStackStampInformation'