under sql server job agent, view job history gets time out error message. How to fix?

Question

Thanks

Answer 1

It looks like you have many data in JOB VIEW history. You may PURGE the jobhistory.

You can keep the history info for last few months and purge the old data using 

sp_purge_jobhistory 
Ref: http://technet.microsoft.com/en-us/library/ms175044.aspx

Answer 2

see

http://www.jamesserra.com/archive/2011/06/easier-way-to-view-sql-server-job-history/

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs