I was lookig for a way to get the description of a schedule/job schedule via Tsql. We found msdb..sp_help_schedule SP and that using msdb..sp_get_schedule_description.
But what a suprise, the description provided by sp_get_schedule_description was not the one we supposed to get for every case.
I searched for a ready to use workaround and found only some statements using the TSql from the sp_get_schedule_description.
Assume one is creating a job with a schedule for every 4 days at 00:03:00. From msdb..sp_get_schedule_description you will get 'Every day at 300' and not the right description
'Every 4 days at 00:03:00'.
Feel free to put the statement into a View, SP or what else you need, to get the right description of a schedule via TSql.
