Failed upgrade Archive Manager from version 4.1.2 to 4.3
There was an error running the script Scripts.4.3.0.2.sql
The specified @category_name ('Archive Manager Batch') does not exist.
Archive Manager installer invokes Scripts 4.3.0.2.sql to update the schedule jobs with category name 'ArchiveManager Batch'. But the job category name was missing.
WORKAROUND:
Run the following SQL statement to create the category name to 'ArchiveManager Batch'.
EXEC msdb.dbo.sp_add_category
@class=N'JOB',
@type=N'LOCAL',
@name=N'Archive Manager Batch' ;
Â
After this try upgrading the product once again.
Run the following SQL query to check the available category name.
exec msdb.dbo.sp_help_category
