Job History

Hello all,
Is there a way to define how much history will be logged in the Job History
window?
I need to save history from the whole last week's run, but it keeps been
deleted.
ThanksLiran
Take a look at sysjobhistory system table
"Liran" <Liran@.discussions.microsoft.com> wrote in message
news:C03C14C4-43ED-4E97-BE97-E71FD083F331@.microsoft.com...
> Hello all,
> Is there a way to define how much history will be logged in the Job
> History
> window?
> I need to save history from the whole last week's run, but it keeps been
> deleted.
> Thanks|||Actually, I did, but the solution is to change the dafault log size in the
SQL Server Agent Property window.
"Uri Dimant" wrote:
> Liran
> Take a look at sysjobhistory system table
> "Liran" <Liran@.discussions.microsoft.com> wrote in message
> news:C03C14C4-43ED-4E97-BE97-E71FD083F331@.microsoft.com...
> > Hello all,
> >
> > Is there a way to define how much history will be logged in the Job
> > History
> > window?
> > I need to save history from the whole last week's run, but it keeps been
> > deleted.
> >
> > Thanks
>
>|||Liran
To modify the maximum number of records maintained in sysjobhistory open
Enterprise Manager and expand the Server to modify. Expand Managment and
Right Click SQL Server Agent and select Properties.
Under the Job System tab there is two text boxes. Maximum job history log
size (rows) and Maximum job hisory rows per job.
-rows per job is the maximum number of rows in sysjobhistory for a
partilcuar job
-log size (rows) is the maximum number rows in sysjobhistory for all jobs
Updating these values will modify how many rows are maintained.
-Peter Ward
WARDY IT Solutions
"Liran" wrote:
> Actually, I did, but the solution is to change the dafault log size in the
> SQL Server Agent Property window.
>
> "Uri Dimant" wrote:
> > Liran
> > Take a look at sysjobhistory system table
> >
> > "Liran" <Liran@.discussions.microsoft.com> wrote in message
> > news:C03C14C4-43ED-4E97-BE97-E71FD083F331@.microsoft.com...
> > > Hello all,
> > >
> > > Is there a way to define how much history will be logged in the Job
> > > History
> > > window?
> > > I need to save history from the whole last week's run, but it keeps been
> > > deleted.
> > >
> > > Thanks
> >
> >
> >