sp_Resubmit_Print

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

See Also

Helpers
Database Tables
Getting Started