Solved

SQL Server 2005 SQL Server Agent job not logging history.

Posted on 2007-11-16
6
1,773 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

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…
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.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

820 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