i have my job running every 5 min. I want to view the history log. In job history it shows only few hundreds of records.. But i want to see from begining. Can anyone tell me, where to view whole log of job history??
The job history cycles over time. I believe only about 5000 records are kept by default. After that, the older ones start getting deleted. If you want to change this, you will need to check under the properties of SQL Agent in SSMS. It should be in the Job section.