NextGen Knowledge Center

Stored Procedure Job

You can create a job within NextGen® Background Business Processor that automatically executes a stored procedure during the times the package is scheduled to run. Each Stored Procedure job can run only one stored procedure. If you want a package to execute more than one stored procedure, you must create a job for each stored procedure.

Configure the following fields:

FileDescription
Stored Procedure NameEnter the name of the stored procedure you want the job to run.
Stored Procedure ParametersSelect the ellipsis button and enter the parameter name and values in the Stored Procedures window. Select OK when finish entering parameters.
Job runtime alert setting (minutes)Indicate the number of minutes you want the application to wait before sending out a job runtime alert email.
Job runtime alert emailEnter the email address of the person or persons to whom the application sends the job runtime alert.