JW Marriott Dubai (the old one close to the airport) has an offer for 1,000 bonus Etihad, Emirates or Saudia miles per weekend stay between October 5 and December 28, 2014.
The weekend night in the Middle East is considered Thursday to Sunday and the Saudia offer requires minimum of two nights stay.
You can access Etihad offer here, Emirates one here and Saudia one here.
Note that these three offers vary and you should check the requirements of each of these offers.
Conclusion
Earning bonus miles for weekend stays can make sense as long as the rate plan associated with this offer is not inflated (as is often the case).