0

Could you suggest please how to create SQL Server Agent job for a stored procedure that have 1 input parameter?

The procedure is correctly created and i executed it using this code :

EXECUTE dbo.MYProcedure N'2016-02-25';

Could you suggest please how to create SQL Server Agent job for a stored procedure that have 1 input parameter?

The procedure is correctly created and i executed it using this code :

EXECUTE dbo.MYProcedure N'2016-02-25'; Is there a way to create a SQL Server Agent job for this procedure that have parameter ?

So i'm trying the basic way that is add this ligne in EXECUTE dbo.MYProcedure N'2016-02-25'; to the window of step in job But the paraméter can change

  • 2
    How is the parameter decided upon? Is it the current date or does the user need to pass it in? Why can the user not simply use a stored procedure? – George.Palacios Apr 16 at 9:58
  • What is the rule that determines the parameter (assuming from your example it is a date)? Can you calculate this with various date functions at run time and pass it to the procedure as a variable? – Libertheme Apr 17 at 6:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.