sp_Resubmit_Sms

sp_Resubmit_Sms

sp_Resubmit_Sns assigns new execution time and releases a given SMS job.

Remarks

This procedure may be called to re-submit any existing job. If @RunWhen parameter is not specified the job will be scheduled for immediate processing. If @Body parameter is omited, an original body will be remain.

Syntax

exec sp_Resubmit_Sms @gKey=..., @jKey=... , @Subject=... , [@Body=... , @RunWhen=... ]

Parameters

Column Name Data type Direction Description Default Status
@gKey uniqueidentifier in Task key gKey found in EVENT_MASTER table Required
@jKey uniqueidentifier in Job key jKey found in OUT_EMAIL table Required
@Subject varchar(255) in revised e-mail subject Required
@Body varchar(8000) in e-mail body null Optional
@RunWhen datetime in new scheduled processing time null Optional

Return Code Values

0 (success) or non-zero (failure)

Examples

To immediately resubmit a job.

----- some code ---
EXEC sp_Resubmit_Sms @gKey, @jKey, 'second attempt'
--- some code ----

See also

OUT_SMS
IN_SMS
sp_After_SMS_Job
sp_On_SMS_In
sp_On_Sms_Status
Configuring SMS Services – Twilio