JDBC Driver for SendGrid

Build 22.0.8462

Schedules

Create, update, delete, and query Campaign Schedules in SendGrid.

Table-Specific Information

Select

The following are examples to query the Schedules table:

SELECT * FROM Schedules

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 True

Id of the campaign.

Status String True

Status of the campaign.

SendAt Datetime False

Date to start the campaign.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462