A plataforma suporta dois caminhos para Categoria:
A) Nativo, para compatibilidade com scripts tradicionais;
B) Wrapper SkyNova, para tracking/ownership da camada Self-Service.

1. CRIAR

EXEC msdb.dbo.sp_add_category
   @class=N'JOB',
   @type=N'LOCAL',
   @name=N'DEV_CAT_NATIVE';
GO

2. CONSULTAR

SELECT
   category_id,
   category_class,
   category_type,
   name
FROM msdb.dbo.syscategories
WHERE category_class=1
 AND name=N'DEV_CAT_NATIVE';
GO

3. MODIFICAR / RENOMEAR

EXEC msdb.dbo.sp_update_category
   @class=N'JOB',
   @name=N'DEV_CAT_NATIVE',
   @new_name=N'DEV_CAT_NATIVE_V2';
GO

5. EXCLUIR

EXEC msdb.dbo.sp_delete_category
   @class=N'JOB',
   @name=N'DEV_CAT_NATIVE_V2';
GO

========================================================================
B. CAMINHO WRAPPER
========================================================================

1. LIMPAR

IF EXISTS
(
   SELECT 1 FROM msdb.dbo.syscategories
   WHERE category_class=1 AND name=N'DEV_CAT_WRAPPER'
)
BEGIN
   EXEC msdb.dbo.usp_TenantSqlAgentCategory_Delete
       @CategoryName=N'DEV_CAT_WRAPPER',
       @CategoryClass=N'JOB';
END;
GO
IF EXISTS
(
   SELECT 1 FROM msdb.dbo.syscategories
   WHERE category_class=1 AND name=N'DEV_CAT_WRAPPER_V2'
)
BEGIN
   EXEC msdb.dbo.usp_TenantSqlAgentCategory_Delete
       @CategoryName=N'DEV_CAT_WRAPPER_V2',
       @CategoryClass=N'JOB';
END;
GO

2. CRIAR

EXEC msdb.dbo.usp_TenantSqlAgentCategory_Create
   @CategoryName=N'DEV_CAT_WRAPPER',
   @CategoryClass=N'JOB';
GO

3. CONSULTAR

SELECT
   category_id,
   category_class,
   category_type,
   name
FROM msdb.dbo.syscategories
WHERE category_class=1
 AND name=N'DEV_CAT_WRAPPER';
GO

4. MODIFICAR / RENOMEAR

EXEC msdb.dbo.usp_TenantSqlAgentCategory_Update
   @CategoryName=N'DEV_CAT_WRAPPER',
   @NewCategoryName=N'DEV_CAT_WRAPPER_V2',
   @CategoryClass=N'JOB';
GO

5. EXCLUIR

EXEC msdb.dbo.usp_TenantSqlAgentCategory_Delete
   @CategoryName=N'DEV_CAT_WRAPPER_V2',
   @CategoryClass=N'JOB';
GO

6. VALIDAÇÃO FINAL

SELECT *
FROM msdb.dbo.syscategories
WHERE name LIKE N'DEV_%';
GO

Resultado esperado: zero linhas.