This site lists final train times from different stations:
http://www.dubaicityinfo.com/DubaiMetro/Dubai_Metro_Train_Timing.aspx
(It should also be posted at the station itself.)
The website says 11pm. Is that right? Does that mean at all stations you can catch the metro up until 11pm, or do you have to arrive at your destination by then?