if you are doing this on FV for the hero's journey achievement the urn is tradable and will complete the achievement without having to do any of the tasks. none of the tasks are required for any other hero's journey achievmenet, so if you buy/borrow the urn from the someone you can save yourself a lot of time
This results in "Tsaph Katta's Urn of Rejuvenation", which can be recharged by handing it into the Head Attendant next to Tsaph Katta's side in Katta Castrum (in the top of the temple reached via one of the portals on the main floor)
He's not sleeping. He's in prologned Stasis, because he was poisoned by Seru and the combine did not have a cure, so rather than let Tsaph die they put him in stasis until a cure could be found.
1st off its probably not and 2nd Its not a waste of time, this is obviously a part for some quest or progression noone has figured out yet, EQ may be ******** but i mean the item has the emperors name in it its most likely a turn in item