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]
exec dbo.custorderhist 'vinet' [This executes the stored procedure custorerhist and passes a parameter of 'vinet' for the customer ID.]
Still have questions? We can help. Submit a case to Technical Support.