Post reply

calling application using stored proc

  • December 13, 2010 at 6:19 am

    #232453

    hello

    i would like to ask if there is a way on calling the windows application using stored procedure, here's the scenario, i have one application that will check the date to launch another application to execute the procedure but the problem is when the windows server restarted then the main application that check the date will not start up.. if there is please in need your help.

    thanks

  • December 13, 2010 at 6:38 am

    #1261663

    I don't think it would be practicably, better would be to get to devise a way to start you application when the server is restarted.

  • December 13, 2010 at 5:57 pm

    #1262000

    You could try to set the sql server to do the following:

    exec sp_configure 'scan for startup procs', '1';

    exec sp_procoption '<procedure>, 'startup', 'on'

    Have the startup proceduer execute xp_cmdshell with the program you need to run.

    The xp_cmdshell is an synchronously process so control would not be returned until the command completes.

    I agree that this is not really practical as it sound like you need the program to run continously and with the correct envirnment. You may want to look into having the program run as a service and start appropriatley seperatly of sql server.

  • December 13, 2010 at 10:23 pm

    #1262029

    thank you guys for the opinion.

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

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