Select * sysjobs

[R7Dave]

Hello

I am trying to write to return job information.

This works...

USE MSDB

select * from sysjobs

In sysjobs, there is a filed called CATEGORY_ID that contains a number.

What table contains category description?

Thanks
Dave

 

[SQLSister]

I'd try syscategories

"NOTHING is more important in a database than integrity." ESquared

 

[memdiscount]

You can read about the table syscategories here:

http://msdn.microsoft.com/en-us/library/ms189757.aspx

Thanks

 

[R7Dave]

Thank you - that is what I needed

How did you know the name? I was not able to see these tables in SQL Server Management Studio.

Thanks
Dave

 

[memdiscount]

You will find it in

System databases - > msdb - > tables - > system tables

Thanks

 

[R7Dave]

I have different access then, I had to ask our administrator for rights this morning.

The 1st table I see under System Tables is dbo.backupfile

Before modifying my rights - I could still query sysjobs without seeing it in Object Explorer

Thanks
Dave