I got this to work using the sa account but not when I run it with a SQL Server account. I gave rights to the SQL Server account to execute the stored procedure as well as the sp_start_job stored procedure.
Any ideas how I can get a generic SQL Server account to work?
Thanks,
Bob