job history

Question

Hi,

We created some maintenance plans that created jobs. These jobs are running daily.

When I checked job history by right clicking on job and view history, some jobs have history for last run and some of them don't have. Although they run successfully. Any idea how to fix this issue. I want to make sure there should be job history by right clicking on job whether it is successful or failed.

Thanks

Answer 1

HiGo to the SQL server management studio --> SQL Server Agent -->select Properties --> History --> Check what is the Maximum  Job History rows per Job incase consider for ex- if you see 100 or <100 or <less than two digit , then if you have for ex

 also ex-If you have 10  jobs on the server that runs daily schedule, and that will cause the 100  or what value exists in ur setting that many rows of logging each, then you'll only see one day or less of history details.

see it what the values set and how many jobs exists. you can change the values.. how u need it

---

Rama Udaya.K ramaudaya.blogspot.com ---------------------------------------- Please remember to mark the replies as answers if they help and un-mark them if they provide no help.

Answer 2

run this query in mamagement studio to know complete details about Backup  JObs

want to know more about other Jobs then replace '%backup%' command wth your command(rebuil,...etc)

select *
from sysjobs j
inner join sysjobsteps js
on j.job_id = js.job_id
where js.command like '%backup%'

---

Ramesh Babu Vavilla MCTS,MSBI