What about a loop.. with a 'WAITFOR DELAY '00:05:00'
Looping continually..


However I think a trigger would be more suitable.
__________________________________________
Anthony Hand
DBA | Systems Integration
Aon Risk Services Australia Ltd
Ph: +61 2 9253 7516
Fax: +61 2 92537952
Mob: +61 415 877 988




Santhosh Kumar
<Santhoshkumar.[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed]
rm-it.com> cc:
bcc:
26/05/2003 05:45 PM Subject: RE: Insertion Check






to do some action for insert/update u create trigger on that table.

so u need not check every 5 mins right ?
Regards,
Santhosh

> ----------
> From: Usman Farhat[SMTP:Usman.[Email Address Removed] Sent: Monday, May 26, 2003 5:45 PM
> To: LazyDBA.com Discussion
> Subject: Insertion Check
>
> Hi Everyone,
> I got to check a table after every five minutes that if there is
any
> record inserted in it ,if there is some new row inserted i got to carry
> out some specific actions. So my problem is to create a procedure that
> checks every five minutes on a particular table whether there is
something
> new inserted in this table or no. How can i carry out this process ? Any
> Idea ?
> Regards,
> Usman
>
> --------------------------------------------------------------------
> NOTA CONFIDENZIALE:
> Questo messaggio ed i suoi allegati sono indirizzati esclusivamente
> alle persone indicate in testa e possono contenere informazioni
> confidenziali. Se avete ricevuto il messaggio per sbaglio, sappiate
> che qualunque utilizzo improprio del contenuto è proibito, Vi
> preghiamo quindi di inoltrarlo immediatamente al mittente e di
> cancellare il messaggio. Per qualsiasi informazione vi inivitiamo a
> contattarci scrivendo a [Email Address Removed] Grazie
>
> CONFIDENTIALITY NOTICE:
> This message and its attachments are addressed solely to the
persons
> above and may contain confidential information. If you have
received
>
> the message in error, be informed that any use of the content
hereof
> is prohibited. Please return it immediately to the sender and
delete
> the message. Should you have any questions, please contact us by
replying
>
> to [Email Address Removed] Thank you
> --------------------------------------------------------------------
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page