Error: "The specified @category_name ('Archive Manager Batch') does not exist" when upgrading AM (4333444)

During an upgrade of Archive Manager, the installer fails and the following error is recorded in the installer log:

"The specified @category_name ('Archive Manager Batch') does not exist"

The SQL Server Agent does not have a Job Category named 'Archive Manager Batch', which is required for the upgrade to proceed.

This typically occurs for one of two reasons:

1. Legacy Naming: In older versions of the product, this category was named 'AfterMail Batch'. The installer is looking for the new name but finds the old one.

2. Missing Category: The Job Category is genuinely missing from the SQL instance.

• Open SQL Server Management Studio (SSMS) and connect to the SQL instance hosting the Archive Manager database.

• Open a New Query window and run the following command to list current categories:

  SQL

  EXEC msdb.dbo.sp_help_category

• Review the results and proceed with the step that matches your scenario:

  Scenario A: You see a category named 'AfterMail Batch' Run the following script to rename the legacy category to the required new name:

  SQL

  EXEC msdb.dbo.sp_update_category
     @class = N'JOB',
     @name = N'AfterMail Batch',
     @new_name = N'Archive Manager Batch'
  GO

  Scenario B: You do NOT see 'AfterMail Batch' or 'Archive Manager Batch' Run the following script to manually create the missing category:

  SQL

  EXEC msdb.dbo.sp_add_category
     @class=N'JOB',
     @type=N'LOCAL',
     @name=N'Archive Manager Batch'
  GO

• Once the category has been renamed or created, re-run the Archive Manager installer.