It does have auto shutdown but I don't know if it works with Snow Leopard. Here is the brochure on it.
http://www.apcmedia.com/salestools/DFAH-84QQXTR0EN.pdf
Here is a review I found on it that I think answers your question:
*Back UPS and Mac--So Happy Together*
*5.0 stars*
*APC Power Saving Back-UPS ES, 10 outlet, 750VA, 120V*
*0 likes*
*Like it*
*Seems to be a great product; of course, I cannot comment on its effectiveness in the event of a power outage as I haven't experienced one since installing it. However, when connecting it up to a Mac running Mac OS X Snow Leopard, the genius and elegance of Mac OS X becomes apparent. Without having to install any drivers, the Mac instantly detects the presence of a UPS, and places a menu item for it in the menu bar at top right, and the System Preferences panel configures itself so that all settings for the UPS can be controlled easily from the System Prefs panel. What more could you ask? Maybe if it made a nice half-caf decaf latte with no whipped and shaved chocolate perhaps?*