Trying to pass user input into a job for a stored procedure

• echotanker

  SSC Enthusiast

  Points: 130

  More actions

  September 10, 2008 at 9:12 am

  #192568

  I have a stored procedure that will ask a user for the month and the year of the records they want deleted. I have placed this stored procedure into a job but when the job is ran it will not ask for user input for the stored procedure. I also have a bat file that will ask for user input to place into the job for the job to run but the job does not accept any user input. How would I pass user input into a job?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  September 10, 2008 at 9:22 am

  #869746

  Jobs are not interactive processes, but batch processes with no user interface.

  😎