Tag: administration
-
Configuring Alerts to Notify Policy deviations in Policy Based Management
In this article we are going to configure alerts for policy management. Alerts are triggered when a violation takes place in a particular policy that uses any of the three automated evaluation mode. Each of these evaluation mode will return an error number starting with 340*. You can use these alerts to notify either policy…
-
Policy Based Management (PBM)
Introduction: Policy based management is one of the new feature added from SQL Server 2008. With the help of this feature you can evaluate an instance or database or objects to bound with in certain conditions policies. If any of the objects or instances failed to bound with in the policy then it can either…
-
Configuring SQL Server Reporting Services
In my previous article we have covered installing reporting service. The next step in reporting service is to configure them according to your environment. There are many options are available in reporting service configuration. You need to configure all these values with respect to your environment. There are two ways to configure reporting service a.)…
-
Trigger to Check Job failures
I was trying to find a alert which could fire immediately upon any of the job failure in the server to send an email. Unfortunately I couldn’t find any the alert related to this. So I thought of writing a DML trigger which should fire immediately when an entry is inserted in sysjobhistory table on…
-
Installing SQL Server Reporting Service
Microsoft SQL Server Reporting Services enables organizations to transform valuable enterprise data into shared information for insightful, timely decisions at a lower total cost of ownership. In this article Im going to install SQL Server 2005 Reporting Services on Windows 2003 machine. Lets discuss about installation of reporting services.