Post reply

vbscript in sql server

  • June 9, 2003 at 8:14 am

    #105872

    Can I schedule my VB application in sql server.If it's possible how can i do that.If not how can schedule my vb script to run at scheduled times.

  • June 10, 2003 at 3:26 am

    #460518

    Your best bet would be to execute your VB Application or VBScript via xp_cmdshell.

    You could then use SQL Agent to schedule the executions of the xp_cmdshell script

  • June 10, 2003 at 11:03 am

    #460621

    thank you very much

  • June 10, 2003 at 11:13 am

    #460624

    when i try to use xp_cmdshell,i am getting an error that could not find the stored procedure 'xp_cmdshell'.

    What should be the reason,how could i come across this one,

    Thanks

  • June 10, 2003 at 1:11 pm

    #460638

    Make sure you're executing the proc. under the mater DB context

    I recommend fully qualified names

    Ex. Exec Master..xp_cmdshell 'c:\test.vbs'

    MW


    MW

  • June 11, 2003 at 12:07 pm

    #460853

    Sometime that XProc is manually renamed or dropped by DBAs due to security issues. You may want to confirm that the proc still exists on the server.

    -Dan


    -Dan

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

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