Sybernet / Supplied Functions Reference
Release 3.00
Mar 03, 2005

HTTP.SP_CRON_WAIT

This function allows your stored procedure to wait for the completion of a procedure submitted to Sybercron.

Syntax

function sp_cron_wait
(
    @ROW_ID                        INT
)

Parameters

Parameter	Description
row_id	The ROW_ID returned from SP_CRON_INSERT.

Returns

For stored procedures 0 if successful. For UNIX executables the exit status.

Example

The following example illustrates how to call sp_cron_wait:

declare
    @row_id int
,   @rslt int
begin
    exec @row_id=http.dbo.sp_cron_insert

        @PROCNAME   = './HelloWorld'
    ,   @SCRIPTNAME = '../htdocs/datafile'

    exec @rslt=http.dbo.sp_cron_wait(@row_id)
    if (@rslt = 0)
        select 'Success!'
    else
        select 'Oops!'
end