Share
Report
7I created a job that executes a SP, which then starts a SQL Agent Job. I made sure all of the permissions were correct, and I am receiving the below error. I used the Execute stored procedure (V2) action, the SQL connection does work as I can select the database and procedure name "sp_start_job". I then get the parameters list, where I tried to enter the job_name. When that didn't work I tried using the job_id instead, but I received the same error.
{
"status": 400,
"message": "Database functions with non-scalar parameters aren't supported.\r\n inner exception: Database functions with non-scalar parameters aren't supported.\r\nclientRequestId: 2a5c1de1-8884-4601-9420-c751d767d242",
"error": {
"message": "Database functions with non-scalar parameters aren't supported.\r\n inner exception: Database functions with non-scalar parameters aren't supported."
},
"source": "sql-ncus.azconn-ncus.p.azurewebsites.net"
}
All responses (
Answers (
