history empty

[aspijker]

Dear people,

We want to implement Sharepoint, but as a DBA I have some problems. Sharepoint has several jobs running every minute. This causes the logfile to be filled with sharepoint messages about the jobs. Now there is no history of my other jobs (from production databases). This is really unacceptable, so I need a way that either:
1) SQL only logs when a sharepoint job failes.
2) SQL doen not log any sharepoint job.

Is there anything I can do to stop this?

Regards, Aspijker

 

[mrdenny]

No you can't stop it. What you can do is increase the number of job history messages which SQL keeps. Right click on the Agent and select properties. There should be a history tab or some sort. On there you can increase the job step history from 1000 steps total and 100 per job to a higher number.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog