Is it possible to query for the job schedule description? Working on putting together a script to analyze all of the active jobs and I have nearly everything I need, but if possible I would like to be able to query for the schedules description as well. Is this possible? I am able to query for the name and ID out of msdb.dbo.sysschedules but it doesn't seem to have the schedules description. Where can I find this information?
You can use sp_help_jobschedule which returns the schedule_description by calling another system proc, sp_get_schedule_description.

exec sp_help_jobschedule @job_name = 'Your Job Name', @include_description = 1


It'd probably be faster to roll this in a cursor instead of breaking apart that system proc which