dcsimg

How to disable/enable all jobs at once

Products

Webtrends Analytics 8.1x
Webtrends Analytics 8.0x
Webtrends Enterprise 7.x
Webtrends Professional 7.x
Webtrends Small Business 7.x

Cause

All jobs, including analysis jobs and system jobs such as backups, must be disabled, or if already disabled, must be re-enabled.

Resolution

To disable and/or re-enable all jobs, follow the steps below.

1. Open a command prompt, and navigate to the \Webtrends\common\database\mysql\bin directory

2. Type the following command and hit Enter:


mysql -u (mysql username) ?p

3. Enter the password and hit Enter.

4. Type the following and hit Enter:

use wt_sched

5. Type the following and hit Enter:

update wt_event set IsEventDisabled=”0″;

Note: Enter IsEventDisabled=”0″ to enable all jobs or enter IsEventDisabled=”1″ to disable all jobs

6. Type the following and hit Enter:
use wtmaster

7. Type the following and hit Enter:
Update wt_profile set profilestatusid=”8″;

Note: Set profilestatusid=”8″ to disable, set profilestatusid=”1″ to make active.

8. Type the following and hit Enter:
exit

All the profiles will have had their analysis status changed at once.

9. Navigate tothe following location:

\Webtrends\storage\config\wtm_wtx\datfiles\profiles

10. Open each .wlp file, and find the[profile]section.

11. Copy and paste in the following and save to disable the profile:

isdisabled = true

Note: Enter false to enable the profiles

12. Save the files

Note: If the profile has been disabled before, the setting may already be present.

More Information

Enabling all jobs will cause them to enter the queue, and this will cause a sudden load on the analysis engine.