sp_Resubmit_File

sp_Resubmit_File

sp_Resubmit_File assigns new execution time and releases a given file 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.

Syntax

exec sp_Resubmit_File @gKey=..., @jKey=... , @Path=... , [ @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_FILE table Required
@Path varchar(255) in UNC file path Required
@RunWhen datetime in new scheduled processing time null Optional

Return Code Values

0 (success) or non-zero (failure)

Examples

To immediately resubmit a job.

-------Sample-------
declare @gKey uniqueidentifier, @jKey uniqueidentifier
 
/* .... some code ... */
 
EXEC sp_Resubmit_File @gKey, @jKey, '\\usnasfs01\$d\test.txt'
 
/* .... some code ... */

See Also

Helpers
Database Tables
Getting Started