I keep the one on the pond on 24/7 during the summer, otherwise it gets green water. On a fishtank, I'd probably just use it when it was really needed. If nothing else, you'll save yourself a few cents a month not running a lightbulb for no reason.
I started running my UV Sterlizer when I ended up with ICK.
I have run it ever since that was a year ago.
Zero impact on the cycle (baterica).
Does not remove tanins - I have driftwood too.
I run 2 filters, 2 heaters, and my UV constantly.
Since the ICK problem - I have not had any issues at all with that tank.