Post reply

vbscript as a job

  • May 23, 2007 at 2:49 pm

    #70176

    is it possible to execute a vb script as a job from within sql server?

  • May 23, 2007 at 3:51 pm

    #708466

    Yes you can use SQL Agent to Execute a VB Script.

    Create a new step.

    Under Type choose "Operating System Command (CmdExec)"

    In command window type the full path of the vbs.

    C:\yourvbscript.vbs

    Alex S

  • May 24, 2007 at 8:11 am

    #708662

    Hi,

    Create a new step.

    Under Type choose "ActiveX"

    Under Language choose "Visual Basic-Script"

    In command window type vbs-code...

    regards

    karl

    Best regards
    karl

  • May 24, 2007 at 10:05 am

    #708702

    Thanks

  • May 24, 2007 at 10:07 pm

    #708842

    You can also call it from xp_CmdShell.

    But, what does the VBScript you want to execute actually do?  Lot's of folks overlook the power built into SQL Server and try to make up for it by using VBScript...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 5 posts - 1 through 4 (of 4 total)

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