Pass Parameter to Job which calls a stored procedure with the parameter provided?

Asked Apr 14 '19 at 13:00

Active Apr 14 '19 at 13:44

Viewed 54 times

I have a stored procedure called sp_Rep_QTR which expects the following parameters: @stardate, @endate.

Now what I want to do is the following: create a job which will EXEC the sp_Rep_QTR at a time (@active_start_time) provided and pass the @stardate, @endate parameters to the stored procedure.

The @stardate, @endate parameters will be passed to a stored procedure which will create the job - these are passed from a web page.

edited Apr 14 '19 at 13:44

marc_s

704,970
168
1,303
1,425

asked Apr 14 '19 at 13:00

Are you asking how to create a agent job using T-SQL? – Larnu Apr 14 '19 at 13:33
This may be of help: https://stackoverflow.com/questions/35135862/create-sql-server-agent-jobs-programatically – Alex Apr 14 '19 at 17:42

Pass Parameter to Job which calls a stored procedure with the parameter provided?

0 Answers0