TABLE 1: Columns in Temporary Table #dba_Scheduled_Jobs
Column Name	Description
job_name	Contains the job's name; the number of times a job name shows up on the list depends on the number of schedules the job has.
job_enabled	Contains one of two possible values: Yes, if the job is enabled, or No, if it's disabled.
schedule_enabled	Contains one of two possible values: Yes, if the schedule is enabled, or No, if it's disabled.
occurs	Stores the job's frequency; the usp_Scheduled_Jobs stored procedure uses the sp_get_schedule_description system stored procedure to populate the occurs column.
start_time	Shows when the job is scheduled to start.
AVG_runtime	Shows the average runtime of the job in seconds.
MAX_runtimee	Shows the job's longest runtime.
MAX_runtimee	Shows the job's longest runtime.
job_id	Stores the job ID.