SQL Server Job simple to use

--querying for those jobs is disabledSELECTjob_id, name, enabled fromMsdb.dbo.sysjobswhereEnabled= 0--Common Job TableSELECT *  fromMsdb.dbo.sysjobs--store information for individual scheduled jobs that will be executed by SQL Server AgentSELECT *  fromMsdb.dbo.sysjobsteps;--contains information for each step in the job that SQL Server agent will performSELECT *  fromMsdb.dbo.sysjobhistory--contains information about SQL Server Agent execution of scheduled jobsSELECT *  fromMsdb.dbo.sysjobstepslogs;--job step log that contains all SQL Server agent job stepsSELECT *  fromMsdb.dbo.sysjobschedules--contains schedule information for jobs that will be executed by SQL Server AgentSELECT *  frommsdb.dbo.sysjobactivity;--log Current SQL Server Agent job activity and statusSELECT *  fromMsdb.dbo.sysjobservers--to store the association or relationship of a specific job with one or more target serversSELECT *  fromMsdb.dbo.sysjobs_view;--SELECT *  fromMsdb.dbo.syscategories--contains categories used by SQL Server Management Studio to organize jobs, alerts, and operators

SQL Server Job simple to use