job_codes

Posted by: cadarsh89

Tagged in: Untagged 

use msdb
select * from sys.sysobjects where name like '%job%' and xtype = 'U'
select * from sys.sysobjects
select * from sysjobservers
select * from sysjobhistory
select * from sysjobs
select * from sysjobactivity
select * from sysjobsteps
select * from sysjobstepslogs
select * from sysjobschedules
select * from sysdbmaintplan_jobs