Re: Execute StoreProcedue in SQL2000 every time i received a replay me

Hi,

1. Create a Task to execute stored procedure
2. Create a message (SP_ADDMESSAGE) to create the subject
3. Using the message ID and Task name create a alert using SP_ADDALERT
4. Trigger the message using RAISERROR statement.

This will automatically fire the Task to execute the stored procedure

Thanks
Hari
SQL Server MVP

"Renato Ribeiro" <RenatoRibeiro@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FA8C6A92-CB30-46B1-A9B8-187F43927B4D@xxxxxxxxxxxxxxxx
> Hi,
> how can i execute a StoreProcedue in SQL2000 every time i received a
> replay
> message with a specific subject, and pass some arguments like the subject.
>
>
> thank in advanced,
>
> Renato Ribeiro
>


.

Relevant Pages

  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQLserver and the WHERE x IN y
    ... to a stored procedure - that would only work if you introduced subtyping into ... the temp table from the calling procedure (the temp table is still in scope, ... INSERT INTO #MyTempTable EXECUTE YourPopulateProc 123 ... INSERT INTO @MyTableVar VALUES ...
    (microsoft.public.sqlserver.programming)
  • RE: SQL stored procedure executing twice
    ... caused the stored procedure to execute twice. ... from one parent record to another. ... Dim stDocName As String ... The table tempCount does not change until I execute the VBA code line: ...
    (microsoft.public.access.modulesdaovba)
  • RE: Stored Procedure performance
    ... >Subject: RE: Stored Procedure performance ... >>In this way the Stored Procedure would only execute once and not on all ... >>On Behalf Of Colin Dawson ...
    (comp.databases.informix)
  • Re: Problem with boolean return parameter of CallableStatement.exe
    ... parameter and it does no updating, so the execute method should return true. ... JDBC driver with Java 1.5.0 06. ... result set and checks that the boolean return parameteris true before then ... Please also show the text of the stored procedure. ...
    (microsoft.public.sqlserver.jdbcdriver)