Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2011-08-09 : 17:51:50
|
| hi all,I have a package that got an input variable say sectionid.I created a job to execute the package .If got an issue how to pass arguments to sp_start_jobi.e one of the steps in the job accepts a parameter say sectionidI have that as one of the variables in my package so how to pass the value of this variable when using sp_start_jobThankssarah |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-10 : 07:47:41
|
| sorry how to you pass parameter to sp_start_job?Anyways for passing parameter to package you can use DTEXEC utility which has argument to specify parameter list along with supplied values------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
sending package parameter values to sp_start_job