sp_Resubmit_Email

sp_Resubmit_Email

sp_Resubmit_Email assigns new execution time and releases a given e-mail 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_Email @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_Email @gKey, @jKey, 'second attempt'
 
/* .... some code ... */

See Also

Helpers
Database Tables
Getting Started