SQL Server Agent job category - Script?

[smedvid]

Any TSQL to create a SQL Server Agent job category?

Tia,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[smedvid]

Got it ... did not search the correct keywords I guess...

IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'CashDaily') < 1
EXECUTE msdb.dbo.sp_add_category @name = N'CashDaily'


Steve Medvid
&quot;IT Consultant & Web Master&quot;

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...