I have a SQL Server Agent job (i.e. a Log Shipping SQL Server Agent Job) that only sustains 2.75-hours (about 15-rows) of history, despite the job properties:
01. Limit size of job history log / Maximum job history log size (in rows): 1000
02. Maximum job history rows per-job: 100
03. Remove agent history (nothing is selected)
The machine is SQL Server 2008 R2SP2. I need to increase that value to 2-weeks. How can I do that? Where would this limit be set?