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

 

Still have questions? We can help. Submit a case to technical support

Last Modified On:
You don't have the appropriate permissions.
No, open a new Support Case