How do you pass the parameter to the job sequence if the job is running at night?

  • Interview Candidate
  • 4
  • 5624

Showing Answers 1 - 4 of 4 Answers

malneedi

  • Sep 29th, 2005
 

Two ways
1. Ste the default values of Parameters in the Job Sequencer and map these parameters to job.
2. Run the job in the sequencer using dsjobs utility where we can specify the values to be taken for each parameter.

  Was this answer useful?  Yes

gagan8877

  • May 8th, 2007
 

You can insert the parameter values in a table and read them when the package runs using ODBC Stage or Plug-In stage and use DS variables to assign them in the data pipeline,
or
pass the parameters using DSSetParam from the controling job (batch job or job sequence) or Job Control Routine from with DS 
or
use dsjob -param from within a shell script or a dos batch file when running from CLI.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions