Running a Stored Procedure Using a Robot Schedule Enterprise Job

You can use Robot Schedule Enterprise to run a stored procedure. Using the SQLCMD command in an agent lets you enter Transact-SQL statements, system procedures, and scripts you want to process.

The example below uses the SQLCMD command in an agent job to execute a script (storeprc.sql). The script contains the steps to execute the stored procedure. Enter this command in the Command Entry tab of your agent job.

sqlcmd -i C:\MyFolder\storeprc.sql -o C:\MyFolder\custordr.txt

When the storeprc.sql script runs, Robot Schedule Enterprise runs the statements inside the script as follows:

USE ABLE; [where ABLE is the database name]

GO

exec dbo.custorderhist 'vinet' [This executes the stored procedure custorerhist and passes a parameter of 'vinet' for the customer ID.]

GO