title: What tables hold the job category class and types?
body: <p>In SQL Server.</p>
  <p>In the table <code>msdb.dbo.syscategories</code> how do I get the value for the ids  <code>category_class</code> and <code>category_type</code> name</p>
  <p>i.e: class 1 = JOB<br>
  type 1  = LOCAL</p>