Hi,
I would like to create an sql server agent job which executes a stored procedure that has multiple parameters.
I looked at the below link but I am not sure how to proceed.
Appreciate your help.
Hi,
I would like to create an sql server agent job which executes a stored procedure that has multiple parameters.
I looked at the below link but I am not sure how to proceed.
Appreciate your help.
Hi @Teen-0523, just wanted to check if you need any other details. If answer helped, you can mark it 'Accept Answer'
Hi @Teen-0523, welcome to Microsoft Q&A forum
I am assuming you are talking about on-premise SQL Server and not Azure SQL. Below is one stack thread that has clear steps to execute a stored procedure with input parameters. It is having one parameter but you can extend the concept to include multiple parameters. Please check the first answer in it:
Create SQL Server Agent job for stored procedure with input parameter
Please let me know if this helps or else we can discuss further.
If answer helps, you can mark it 'Accept Answer'
11 people are following this question.