<< SQLCMD Login/User create template | "Your login attempt was not successful. Please try again." >>

SQL Agent - job history set number of rows

by Administrator 2. July 2008 00:23

USE [msdb]
GO
EXEC msdb.dbo.sp_set_sqlagent_properties
@jobhistory_max_rows=200000,
@jobhistory_max_rows_per_job=10000
GO

a2ffe81d-ff0e-481f-a7dc-7a5cd59ffb3a|0|.0

Tags: t-sql, sql agent

Categories:

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (0) | Post RSS RSS comment feed

RSS comment feed

Related posts

Can't drop or edit SQL Agent job after changing server nameHaving trouble editing or dropping a job on a SQL Server that you renamed the NT server for? S...Using SQLAgent Tokens - Automatically add a scheduleAutomatically add a schedule to a SQL Agent job. This example adds one that will run two hours from ...Msg 1934, Sev 16: UPDATE STATISTICS failed because the following SET options have incorrect settings: 'ARITHABORT'.Got this when I ran my sp__updatestats procedure in a SQL Agent jobstep, but it worked in Query Anal...

Add comment

Name*
E-mail*
Website
Country Country flag

b i u quote

Comment
Preview

Notify me when new comments are added