Sybernet / Supplied Procedures Reference
Release 3.00
Mar 03, 2005
backwards forwards

HTTP.SP_SYBERSCRIPT

This procedure allows you to use SP_HTML_CRON_REGISTER to register UNIX scripts with Sybercron. That application program allows you to only select stored procedures from the current schema, thus to register a script you must either call SP_CRON_INSERT manually or you can use this stored procedure with the register.

Syntax

procedure sp_Syberscript
(
    @SHELLSCRIPT                   VARCHAR(255)
,   @ARG1                          VARCHAR(255)
,   @ARG2                          VARCHAR(255)
,   @ARG3                          VARCHAR(255)
,   @ARG4                          VARCHAR(255)
,   @ARG5                          VARCHAR(255)
,   @ARG6                          VARCHAR(255)
,   @ARG7                          VARCHAR(255)
,   @ARG8                          VARCHAR(255)
,   @PLATFORM                      VARCHAR(30)
,   @SENDER                        VARCHAR(255)
)   ;

Parameters

Parameter Description
shellscript
 
The name of your script or executable.
arg1
 
An optional argument passed to your script.
arg2
 
An optional argument passed to your script.
arg3
 
An optional argument passed to your script.
arg4
 
An optional argument passed to your script.
arg5
 
An optional argument passed to your script.
arg6
 
An optional argument passed to your script.
arg7
 
An optional argument passed to your script.
arg8
 
An optional argument passed to your script.
platform
 
The name of the platform where Sybercron is running from.
sender
 
Your e-mail address.

Example

The following example illustrates how you might invoke this procedure manually:

exec http.dbo.sp_Syberscript

    @SHELLSCRIPT    = './ldapmodify'
,   @ARG1           = 'ldif.update'
,   @PLATFORM       = 'ORADEV'
,   @SENDER         = 'nospam@nospams.com'

See Also

SP_CRON_INSERT
SP_CRON_INSERT_PARAMETER
SP_HTML_CRON_REGISTER


Sybernet is a trademark of SRI International.
Copyright © 1996-2008 SRI International. All Rights Reserved.
Denis D. Workman / http://Sybernet.sri.com/