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. |