[ENH] ActivityProviders are being executed mutiple times

## Enhancement Request

### Enhancement Overview
ActivityProviders are being executed multiple times, i.e. they are being called twice at service startup, and every time any workflow is published, retracted or deleted, and in some cases, when a new workflow is created.

### Proposed Enhancement
ActivityProviders should be executed when the service starts up (and if possible, when manually triggered) as some ActivityProviders have extensive work to do and this might delay the publication, retraction, deletion and the creation of workflows.

### Alternative Solutions
Developers can check if there were any changes to their logic, and re-execute their code if any, otherwise they can just return from the method.

Start by tracing where ActivityProviders are invoked during service startup and workflow publish, retract, delete, and creation operations. Compare the duplicate calls and determine how a manual trigger could fit; done means providers run at startup, optionally on demand, without delaying those workflow operations.

Written by the indexing model from the issue text.