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.