Ignite Alteration: Default Plan Collection Time#LR14362
By default Ignite will collect information on query plans at 12:33 AM local time (well, local to the time on the server where the Ignite PI service is running). For some customers this is not the best time for the plan collection to run. If you have ever wanted to change the time for the plan collection then you are probably already aware that you cannot do this through the Ignite GUI.
Fear not, as we have a simple workaround to offer you. Just follow these steps:
1. Login to the Ignite repository
2. Find the Ignite ID for this database instance
SELECT id, name --use the ID value in the query below FROM cond ORDER BY name;
3. See what the current schedule is:
SELECT * FROM con_plan_collection_schedule WHERE databaseid=<ID for instance>
4. Modify the BASEHOUR field to change the hour it executes.
UPDATE con_plan_collection_schedule SET basehour = X
You can set X to be any hour of the day between 0-23. For example, if you use 3 then the plan collection will run at 3:33 am for that database.