Lost Retention Scheme Job Settings

Oct 28, 2009 at 1:52 PM

I understand that the Retention Scheme Job Settings are created by default during install. I didn't fully understand the GUI and I made the mistake of changing the type and somehow deleting the ConnectionString that it used.

Could someone post the default settings for that SQL Monitor so that I can modify it to suit my needs instead of me doing it incorrectly.

Thanks

Developer
Oct 28, 2009 at 1:55 PM

Sure:

<SQLMonitor>
    <ConnectionString>Provider=SQLOLEDB.1;Data Source=Christopherha;Initial Catalog=Polymon; Integrated Security=SSPI;</ConnectionString>
    <SP>
        <Name>agg_Monitor_ApplyRetentionScheme</Name>
        <Parameters>
        </Parameters>
    </SP>
</SQLMonitor>

Oct 28, 2009 at 2:14 PM

Thank you for the quick reply. That's exactly what I needed.