Hi Ganesh

I know this was some time ago but I have the same problem and I'm wondering if you ever found a solution. If you have, please share, if not, then the links below may help.

So far I've found these ideas but haven't had a chance to test them out yet

http://manjunathcbhat.wordpress.com/2011/04/24/get-information-on-all-jobs-running-on-a-sql-server-instance/

http://www.sqlservercentral.com/Forums/Topic768256-149-2.aspx

regards

Derek

ps Good luck with the whole elephant God thing.