JobCategory

New-DbaAgentJobCategory

Sander Stad (@sqlstad), sqlstad.nl

New-DbaAgentJobCategory View Source Sander Stad (@sqlstad), sqlstad.nl Windows, Linux, macOS Synopsis Creates new SQL Server Agent job categories for organizing and managing jobs. Description Creates custom job categories in SQL Server Agent to help organize and classify jobs by function, department, or priority level. Job categories provide a way to group related jobs together for easier management and reporting, replacing the need to manually create categories through SQL Server Management Studio.

Remove-DbaAgentJobCategory

Sander Stad (@sqlstad, sqlstad.nl)

Remove-DbaAgentJobCategory View Source Sander Stad (@sqlstad, sqlstad.nl) Windows, Linux, macOS Synopsis Removes SQL Server Agent job categories from one or more instances. Description Removes custom SQL Server Agent job categories that are no longer needed for job organization and management. This is useful when cleaning up obsolete categories after reorganizing jobs or migrating workloads between environments. Any jobs currently assigned to a removed category will automatically be reassigned to the default “[Uncategorized (Local)]” category.

Set-DbaAgentJobCategory

Sander Stad (@sqlstad), sqlstad.nl

Set-DbaAgentJobCategory View Source Sander Stad (@sqlstad), sqlstad.nl Windows, Linux, macOS Synopsis Renames SQL Server Agent job categories to standardize naming conventions across instances. Description Renames existing SQL Server Agent job categories by updating their names in the msdb database. This is particularly useful for standardizing job category naming conventions across multiple environments or correcting categories that were created with inconsistent names. The function validates that source categories exist and prevents renaming to names that already exist, helping maintain clean job organization within SQL Server Agent.