Prev: Location Intelligence demo
Next: need to establish sound backup/maintenace/security practices
From: tarun on 30 Mar 2010 14:30
SQL Server 2000 - To access the SQL Server Agent Job History in Enterprise Manager, navigate to:
Root
SQL Server Instance
Management
SQL Server Agent
Right click on SQL Server Agent
Select the 'Properties' option
Select the 'Job System' tab
In SQL Server 2000, it is possible to permit automatic deletions based on the values for the 'Maximum job history log size (rows)' and 'Maximum job history rows per job'. If you do not want SQL Server to automatically delete the data, uncheck the 'Limit size of job history log' check box.
----------------------------------------------
SQL Server 2005 - To access the SQL Server Agent Job History in Management Studio, navigate to:
Root
SQL Server Instance
SQL Server Agent
Right click on SQL Server Agent
Select the 'Properties' option
Select the 'History' page




Mark D Powell wrote:

Need to increase Job History SQL Server 2005
25-Mar-10

We have an application uses SQL Server 2005's sqlagent job feature to
runs around 20 jobs which a frequency of every 1, 2, 5, or 10 minutes
depending on the job.

Every now and then one of these job runs will error however by the
time anyone notices the job run history information is cleared from
the MSDB job history tables.

Anyone know where I can set the size/retention for job history?

Thanks
-- Mark D Powell --

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Making Silverlight Emulate Synchronous Requests
http://www.eggheadcafe.com/tutorials/aspnet/91f69224-3da5-4959-9901-c5c717c9b184/making-silverlight-emulat.aspx
From: Mark D Powell on 2 Apr 2010 10:03
On Mar 30, 2:30 pm, tarun kumar wrote:
> SQL Server 2000 - To access the SQL Server Agent Job History in Enterprise Manager, navigate to:
> Root
> SQL Server Instance
> Management
> SQL Server Agent
> Right click on SQL Server Agent
> Select the 'Properties' option
> Select the 'Job System' tab
> In SQL Server 2000, it is possible to permit automatic deletions based on the values for the 'Maximum job history log size (rows)' and 'Maximum job history rows per job'.  If you do not want SQL Server to automatically delete the data, uncheck the 'Limit size of job history log' check box.
> ----------------------------------------------
> SQL Server 2005 - To access the SQL Server Agent Job History in Management Studio, navigate to:
> Root
> SQL Server Instance
> SQL Server Agent
> Right click on SQL Server Agent
> Select the 'Properties' option
> Select the 'History' page
>
> Mark D Powell wrote:
>
> Need to increase Job History SQL Server 2005
> 25-Mar-10
>
> We have an application uses SQL Server 2005's sqlagent job feature to
> runs around 20 jobs which a frequency of every 1, 2, 5, or 10 minutes
> depending on the job.
>
> Every now and then one of these job runs will error however by the
> time anyone notices the job run history information is cleared from
> the MSDB job history tables.
>
> Anyone know where I can set the size/retention for job history?
>
> Thanks
> -- Mark D Powell --
>
> Previous Posts In This Thread:
>
> Submitted via EggHeadCafe - Software Developer Portal of Choice
> Making Silverlight Emulate Synchronous Requestshttp://www.eggheadcafe.com/tutorials/aspnet/91f69224-3da5-4959-9901-c...

Thank you. I have emailed this information to myself so when I get
back to work I can apply this. Naturally I think to look everywhere
but the right place.

-- Mark D Powell --
From: Mark D Powell on 7 Apr 2010 09:44
On Apr 2, 10:03 am, Mark D Powell <Mark.Powe...(a)hp.com> wrote:
> On Mar 30, 2:30 pm, tarun kumar wrote:
>
>
>
>
>
> > SQL Server 2000 - To access the SQL Server Agent Job History in Enterprise Manager, navigate to:
> > Root
> > SQL Server Instance
> > Management
> > SQL Server Agent
> > Right click on SQL Server Agent
> > Select the 'Properties' option
> > Select the 'Job System' tab
> > In SQL Server 2000, it is possible to permit automatic deletions based on the values for the 'Maximum job history log size (rows)' and 'Maximum job history rows per job'.  If you do not want SQL Server to automatically delete the data, uncheck the 'Limit size of job history log' check box.
> > ----------------------------------------------
> > SQL Server 2005 - To access the SQL Server Agent Job History in Management Studio, navigate to:
> > Root
> > SQL Server Instance
> > SQL Server Agent
> > Right click on SQL Server Agent
> > Select the 'Properties' option
> > Select the 'History' page
>
> > Mark D Powell wrote:
>
> > Need to increase Job History SQL Server 2005
> > 25-Mar-10
>
> > We have an application uses SQL Server 2005's sqlagent job feature to
> > runs around 20 jobs which a frequency of every 1, 2, 5, or 10 minutes
> > depending on the job.
>
> > Every now and then one of these job runs will error however by the
> > time anyone notices the job run history information is cleared from
> > the MSDB job history tables.
>
> > Anyone know where I can set the size/retention for job history?
>
> > Thanks
> > -- Mark D Powell --
>
> > Previous Posts In This Thread:
>
> > Submitted via EggHeadCafe - Software Developer Portal of Choice
> > Making Silverlight Emulate Synchronous Requestshttp://www.eggheadcafe.com/tutorials/aspnet/91f69224-3da5-4959-9901-c...
>
> Thank you.  I have emailed this information to myself so when I get
> back to work I can apply this.  Naturally I think to look everywhere
> but the right place.
>
> -- Mark D Powell --- Hide quoted text -
>
> - Show quoted text -

Update. I cannot believe I overlooked the history tab on the sqlagent
properties. It is working fine and naturally no errors had occurred
since I may not have enough history to look up the details. Thanks
again.

-- Mark D Powell --
 | 
Pages: 1
Prev: Location Intelligence demo
Next: need to establish sound backup/maintenace/security practices