Does XPSSweeper gets executed (or called internally) whenever we restart Policy Server Services?
- No, XPSSweeper doesnt run when policy server is started/restarted.
If not, can I schedule it using XPSExplorer?
- Yes and it is the suggested way as noted in the document XPSSweeper - CA Single Sign-On - 12.52 SP2 - CA Technologies Documentation
Do I need to consider anything before enabling it?
- Look out for "Note:" on the above referenced document for suggestions.