SchedSubscriptions Table

The SchedSubscriptions table stores alerts that are set to be sent on a daily or weekly basis.

Warning  Modifying the database schema or database structures is unsupported. Changes that you make to the database contents may be overwritten when you install updates or service packs for Windows SharePoint Services, or when you upgrade an installation to the next product version.

Columns

Column name	Data type	Description
Id	uniqueidentifier	ID of the alert.
SiteId	uniqueidentifier	ID of the SharePoint site with which the alert is associated. GUID links to the Sites table.
NotifyFreq	int	Value that indicates how frequently the alert is sent. 1 for daily; 2 for weekly.
WebId	uniqueidentifier	ID of the Web site with which the alert is associated. GUID links to the Webs table.
ListId	uniqueidentifier	ID of the list to which an alert is added. GUID links to the Lists table.
ItemId	int	ID of the item to which an alert is added. Linked to the UserData table. If the entire list is added to an alert, the field is null.
EventType	int	Event that triggers the alert.
UserId	int	ID of the user who configured the alert.
UserEmail	nvarchar	E-mail to which the alert is sent.
SiteUrl	nvarchar	URL of the site.
WebUrl	nvarchar	URL of the subsite if there is one.
WebTitle	nvarchar	Title of the Web site.
WebLanguage	int	Language ID of the Web site.
WebLocale	int	Locale ID of the Web site.
WebTimeZone	smallint	Value that indicates the time zone.
WebTime24	bit	Time format specifier. Specifies whether the time displayed is in 12-hour or 24-hour format.
WebCalendarType	smallint	Calendar type for non-Gregorian calendars, e.g., Hijiri.
WebAdjustHijriDays	smallint	Lunar calendar information.
ListUrl	nvarchar	URL of the list.
ListTitle	nvarchar	Title of the list.
ListBaseType	int	Title of the list.
ListServerTemplate	int	Base type of a list such as a survey, document library, or events list.
ItemDocId	uniqueidentifier	ID of the document used with alerts.