sp_Resubmit_Print
sp_Resubmit_Print assigns new execution time and releases a given print 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. The printer must be registered under Stinky service account profile on application server where Stinky services are installed.
Syntax
exec sp_Resubmit_Print @gKey=..., @jKey=... , @Printer_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_PRINT table | Required | |
@Printer_Path | varchar(255) | in | UNC printer 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_Print @gKey, @jKey, '\\server_name\printer_nanme' /* .... some code ... */ |