Return
-
Title
How to place all jobs ON HOLD in TIC environment -
Description
Is there a way to place all the jobs on hold in a TIC environment? -
Resolution
There are two kinds of schedule jobs in TIC and there are two different ways to place each on hold.For a scheduled Snapshot:1. Stop service of Toad Database Server (Toad Intelligence Central)2. Stop service of Toad Optimization Server (Toad Intelligence Central)3. Go to TIC installation folder and find out datahub.cnf.4. Modify the setting of 'event_scheduler=on' to 'event_scheduler=off'.5. Restart previously stopped services.To resume, follow above steps but just roll back the setting to 'event_scheduler=on'.For scheduled Automation Scripts, run attached on_hold_automation_scripts.sql with root user to put them on hold. You can then run attached resume_on_hold_automation_scripts.sql with root user to resume the schedule jobs. -
Attachments