History Limit

I use SQL Server Management Studio and when I View History for a Job there
seem to be a 100 line limit. Some of my jobs have more than 100 steps so
some don't show. Is there a place you can increase that limit a bit?
Thanks
John
Yes -
Check properties of SQL Server Agent and then go to History.
There you can play with your settings.
Enjoy
Immy
"John Holt" <johnh@.regionv.k12.mn.us> wrote in message
news:uAdCacj4GHA.512@.TK2MSFTNGP06.phx.gbl...
>I use SQL Server Management Studio and when I View History for a Job there
>seem to be a 100 line limit. Some of my jobs have more than 100 steps so
>some don't show. Is there a place you can increase that limit a bit?
> Thanks
> John
>
|||John Holt wrote:
> I use SQL Server Management Studio and when I View History for a Job there
> seem to be a 100 line limit. Some of my jobs have more than 100 steps so
> some don't show. Is there a place you can increase that limit a bit?
> Thanks
> John
>
Right-click on SQL Server Agent, choose Properties, go to the History tab...
Tracy McKibben
MCDBA
http://www.realsqlguy.com