Post reply

Start a process and return

  • January 10, 2008 at 11:36 pm

    #377912

    This post is from another forum where I am a strong member, and I would like to help the member get an answer fast.

    [Quote]I'm trying to start a process from a trigger on a SQL Server table.

    I need to launch the process in the background - basically 'fire and forget'.

    The only option I see on xp_cmdshell is for no_output - which doesn't help at all.

    I tried making an EXE for the trigger to execute, then have that program get the process started then return, but it still waits. Calling Shell with Wait=false doesn't do any better.

    Any idea what I can do to get a process started then return? Thanks.[/Quote]

    Regards,

    goodguy

    Experience is a bad teacher whose exams precede its lessons

  • January 11, 2008 at 4:32 am

    #767031

    Schedule a job for the next second.

    Job must be created earlier. Trigger just should schedule it for one-off execution as GETDATE() + 1s.

    _____________
    Code for TallyGenerator

  • January 11, 2008 at 4:54 am

    #767034

    Thanks, Sergiy, I'll pass it on.

    Regards,

    goodguy

    Experience is a bad teacher whose exams precede its lessons

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

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