January 10, 2008 at 11:36 pm
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]
January 11, 2008 at 4:32 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply