dbTalk Databases Forums  

can you call a command line\batch file from a triger ?

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss can you call a command line\batch file from a triger ? in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
andy
 
Posts: n/a

Default can you call a command line\batch file from a triger ? - 11-17-2007 , 07:56 PM






eg. new row inserted into DB fires off a command line batch
file ?

Reply With Quote
  #2  
Old   
Frank Ploessel
 
Posts: n/a

Default Re: can you call a command linebatch file from a triger ? - 11-18-2007 , 06:57 AM






Andy,

I would call the system procedure xp_cmdshell from the trigger.

Frank

On Sun, 18 Nov 2007 02:56:47 +0100, <andy> wrote:

Quote:
eg. new row inserted into DB fires off a command line batch
file ?


Reply With Quote
  #3  
Old   
 
Posts: n/a

Default Re: can you call a command linebatch file from a triger ? - 11-18-2007 , 10:20 AM



In article <op.t1znlhh4j0bybf@computer>, fpl...
@d_e.i_m_s_h_e_a_l_t_h.c_o_m says...
Quote:
Andy,

I would call the system procedure xp_cmdshell from the trigger.

Frank

On Sun, 18 Nov 2007 02:56:47 +0100, <andy> wrote:

eg. new row inserted into DB fires off a command line batch
file ?
Yes, that works fine; I do it in a very busy production app.

--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.