sp_add_jobstep @database_name=

• Henrik Staun Poulsen

  SSCertifiable

  Points: 6579

  More actions

  May 24, 2004 at 1:22 pm

  #108057

  In my install script, I would like my sp_add_jobstep to have a @database_name= parameter, with information from an environment variable.

  Is this posible?

  I use the environment variable in all my DTS packages, so that these can run regardless what the current name of the database is (it changes almost as often as I change shirts <g&gt.

  I've searched thru BOL and Google, but cannot get anything useful.

  TIA

  Henrik Staun Poulsen

  Denmark

• jordanac

  Hall of Fame

  Points: 3653

  More actions

  May 25, 2004 at 2:09 am

  #507590

  The sp  sp_add_jobserver can be used  at creation but it is at the JOBLEVEL.....

  
  Andy.

• Henrik Staun Poulsen

  SSCertifiable

  Points: 6579

  More actions

  May 25, 2004 at 2:45 am

  #507597

  Andy,

  Thanks, I'm calling sp_add_jobschedule just above the sp_add_jobstep. But my question is probably not clear...

  I'm after the contents of an envirronment variable, so that I can get the job to run at the right database.

  TIA

  Henrik