.Rdl file or sql code

I have n number of servers and on each server there are x number of jobs are scheduled. so can anyone provide me a .rdl file  or SQL code for ALL the servers job history(success/failure..etc).

Thanks. 

Do you mean, how can you gather all that information in one report? Well, that I can't give you in the hand, but I can help you get that information.

Take a look into my post about subscriptions:

http://www.bidn.com/blogs/marcoadf/bidn-blog/340/subscriptions-how-to-manage-them

I believe you are interested in the information from sysjobs table and maybe from Executionlog (http://www.bidn.com/blogs/marcoadf/bidn-blog/570/ssrs-information-about-reports-ran).

Let me know if you need further help.