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