Schedules
Create, update, delete, and query Campaign Schedules in SendGrid.
Table-Specific Information
Select
The following is an example to query the Schedules table:
SELECT * FROM Schedules WHERE MarketingCampaignId = '123'
Insert
Provide MarketingCampaignId and SendAt to schedule a campaign at a specific time. You can simply specify SendAt to immediately send a campaign. SendGrid requires that both the html and plain text content have an [unsubscribe] tag in them for a campaign to be sent.
INSERT INTO Schedules (MarketingCampaignId) VALUES (3091692)
INSERT INTO Schedules (MarketingCampaignId, SendAt) VALUES (1, '11/11/2018')
Update
You can only update Schedules by specifying a MarketingCampaignId.
UPDATE Schedules SET SendAt = '01-01-2016' WHERE MarketingCampaignId = '123'
Delete
You can only delete Schedules by specifying a MarketingCampaignId.
DELETE FROM Schedules WHERE MarketingCampaignId = '123'
Columns
| Name | Type | ReadOnly | References | Description |
| MarketingCampaignId [KEY] | Integer | False |
Id of the campaign. | |
| Status | String | True |
Status of the campaign. | |
| SendAt | Datetime | False |
Date to start the campaign. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| AccountId | String |
The ID of the account. |
| SubuserUsername | String |
The username of the subuser. |