Solved

SQL Server 2005 SQL Server Agent job not logging history.

Posted on 2007-11-16
6
1,769 Views
Last Modified: 2012-08-13
I have a particular job that isn't recording any history.  Either when it runs successfully or when it fails.  Other jobs on the same instance are recording history just fine.  Anyone have any idea where to begin looking?
0
Comment
Question by:lostboyinsofla
  • 3
  • 2
6 Comments
 
LVL 10

Expert Comment

by:AustinSeven
Comment Utility
I'm not aware of any way to configure a specific job to stop logging history.   It's an unusual problem.   Try scripting out the job, deleting the job and then re-creating it by running the script.   Alternatively, if it's a simple job, start from scratch and manually create the job, job step(s) and schedule.   Also, does restarting the Agent service have an effect?

AustinSeven
0
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
Comment Utility
make sure you have fresh sp for sql server 2005 (at least sp1)
---
in SSMS -> open your server-> find sql Server agent -> right click on sqlserver agent-> open sql Server agent properties->
select page->click ' History'->make sure 'Limit size of job history log' is checked
and Max set too (if you are not space limited -> select max job history rows per job 1000
Max job history log size 10000
and try again... post result
0
 

Author Comment

by:lostboyinsofla
Comment Utility
My History properties were set to 1000 and 100 respectively.  I changed the max to 1000 because that is the high limit SQL server imposes.  The max was previously set to 100.

Still doesn't explain why NO history had been recorded though.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 42

Expert Comment

by:EugeneZ
Comment Utility
Can you see history?


what service pack  do you have?
---
also if somebody deleted data from  sysjobhistory table
or manually from job

---

check
http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=87325&enterthread=y
0
 

Author Comment

by:lostboyinsofla
Comment Utility
I can't see any history on that specific job but can on others.  I'm running SP2.  No one has deleted the history.
0
 
LVL 42

Expert Comment

by:EugeneZ
Comment Utility
-check sqlagent log errors and it may help:
     if it did not help:
                    - try to restart the sqlagent
                                         if it didnot help:
                                                  - script the job\ delete-recreate it: test
Post results
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now