USP_DATALIST_EMAILSCHEDULE

CREATE procedure dbo.USP_DATALIST_EMAILSCHEDULE(
@SCHEDULENAME nvarchar(256) = null,
@CLIENTSITESID int = null
)

as
    set nocount on;

    select 
       ID,
           SCHEDULENAME AS Name,
           LASTRUN as LastRun,
           SCHEDULEENABLED AS Enabled,
           CLIENTUSERSID as OwnerID,
           CLIENTSITESID
  from dbo.EMAILSCHEDULE
  where (@SCHEDULENAME is null OR SCHEDULENAME like '%'+@SCHEDULENAME+'%')
  and (@CLIENTSITESID is null or CLIENTSITESID = @CLIENTSITESID)