Post reply

sp_add_jobstep @database_name=

  • 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

  • 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.

  • 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

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

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