Le Rhun Philippe (8/7/2008)
I'm looking for the way to change default values for those two option in SQL Server Agent Properties :
Maximum job history log size : default to 1000
Maximum job history row per job : default to 100
And because I want to script those values I don't want to change it in EM but by using QA
I don't find any SP to change it and I don't know WHERE these default values are stored (which table ?).
Di someone could help me ??
EXEC msdb.dbo.sp_set_sqlagent_properties @jobhistory_max_rows=2000,
Andras Belokosztolszki, MCPD, PhD