souris wrote:
> I have an app to download data from mainframe daily.
> I am looking for a method to avoid user run the stored procedure 2
> times per day.
>
> I am thinking to have a SystemConfigure table to store
> Last_update_Date field.
> If the data equal today then do nothing, if less then download from
> mainframe.
> Update the data to current date after download.
>
> Are there any better solution for this method?
>
> Any information is great appreciated
>
> Souris,

"souris" <soukkris@viddotron.com> wrote in message
news:Owrf26hGFHA.2136@TK2MSFTNGP14.phx.gbl...
> I have an app to download data from mainframe daily.
> I am looking for a method to avoid user run the stored procedure 2 times
per
> day.
>
> I am thinking to have a SystemConfigure table to store Last_update_Date
> field.
> If the data equal today then do nothing, if less then download from
> mainframe.
> Update the data to current date after download.
>
> Are there any better solution for this method?