Post reply

How to pass optional parameters in SQL Server agent job

  • June 14, 2012 at 3:50 am

    #275765

    Hi,

    Created SP and package with below parameters

    Year

    Code

    Batch

    Year is Mandatory.

    Created SQL Server Agent Job.

    Could you please let me know how to use/pass optional parameter in SQL Server job agent

    Regards

    SqlStud

  • June 15, 2012 at 2:47 am

    #1501446

    Hi,

    Could you please let me know how to set the mandatory and optional parameters in SQL Server Agent job?

    Regards

    SqlStud

  • June 18, 2012 at 12:42 am

    #1502095

    Any solutions on this?

    Regards

    SqlStud

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply