Passing values between procedures

[FatalExceptionError]

I have a procedure that has to run every minute. It queries data based on the time among other things. In case an error occurs in operation of the procedure and a minute or two (or more) get skipped i need to get the data within the time frame that execution failed. Is there a way to pass data between the same procedure. I need the last successful time to be passed to the next successful execution.

=======================================
The statement below is true
The statement above is false

There are 10 kinds of people, those who know binary and those who don't

 

[SQLDenis]

Store the value in a ProcessInfo table so that you can have a log for reference.

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[FatalExceptionError]

Is ProcessInfo a table I create or is it one available specifically for things like this.

=======================================
The statement below is true
The statement above is false

There are 10 kinds of people, those who know binary and those who don't

 

[SQLDenis]

you will have to create one

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/