Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
Goals and Symptoms
Information Manager archive job fails during step 6.
In the Archive Job History, step 6 gives the following error:
Unable to start execution of step 6 (reason: the ActiveScripting subsystem failed to load (see the SQLAGENT.OUT file for details); the Job has been suspended). The Step Failed.
The following error is displayed in the SQLAGENT.OUT log:
! [LOG] Step 6 of job 'Archive SMS-3000 Data' (0xFD0BF3FE094519469A3873D48CAF032D) cannot be run because the ActiveScripting subsystem failed to load. The job has been suspended
Causes and Fixes
An incorrect registry string is causing the job to fail. This can occasionally occur after a MSDE upgrade/patch.
Warning: Making incorrect changes to the registry can cause the system to become unstable. Always create a backup of the registry before making any changes.
1. Open the Windows Registry Editor (Start->Run->Regedit)
2. Navigate to [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup]
3. Verify that the path of the key SQLPATH is correct. In some instances, the "s" at the end is missing.
C:\Program Files\Microsoft SQL Server\80\Tools
4. Re-run the SMS Archive Job