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 96 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

732,580
175
1,330
1,459

asked Apr 14 '19 at 13:00

Are you asking how to create a agent job using T-SQL? – Thom A 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