Solved

SQL Server 2005 SQL Server Agent job not logging history.

Posted on 2007-11-16
6
1,770 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
ID: 20297732
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
ID: 20297917
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
ID: 20298064
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 42

Expert Comment

by:EugeneZ
ID: 20298332
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
ID: 20299466
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
ID: 20300070
-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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

932 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

14 Experts available now in Live!

Get 1:1 Help Now