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