USP_DATALIST_EMAILSCHEDULE_ACTIVESCHEDULES

                CREATE procedure dbo.USP_DATALIST_EMAILSCHEDULE_ACTIVESCHEDULES
                as
                    set nocount on;

                    select S.ID, S.SCHEDULENAME, S.EMAILTEMPLATEID, S.TIMETOQUEUE, S.LASTRUN, TZ.Name 'TIMEZONENAME',
                           R.RECURRENCETYPE, R.INTERVAL, R.DAYOFWEEK, R.DAY, R.WEEK, R.MONTH, R.STARTDATE, R.ENDDATE,
                           S.CLIENTSITESID
                    from dbo.EMAILSCHEDULE S
                    inner join dbo.RECURRENCE R
                    on R.ID = S.RECURRENCEID
                    inner join dbo.TIMEZONE TZ
                    on TZ.ID = S.TIMEZONEID
                    where S.SCHEDULEENABLED = 1