on 03-23-2010 11:06 AM
Hi All,
I need to run a stored procedure once in a day.I have the following questions while using ATP for this.
>> If i use ATP to achieve this,how to make sure that the stored procedure will be executed only once.
>>Do we need to maintain ATP manually on each system or it will be transported with the Comm channel?
>> what happens to ATP settings when the PI system restarts?
I appreciate your help.
Thanks,
Monish
Monish,
Choose the Daily option in the ATP - Select Duration as 1 Hour. In your communication channel set the Polling Interval as 60 Minutes. Doing so , you can avoid the Stored Procedure to run twice.
I believe the settings will not be removed by restarting the server.
It's not transportable. You have to maintain the settings on each system.
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Monish,
I would suggest to include a check inside your stored procedure. Create a table containing procedure_id and process_timestamp fields. Once your procedure gets called from XI, check wether an entry with process_timestamp for the current day exist. If so, don't execute procedure. If not insert new process_timestamp along with procedure_id.
Thus you can guarantee that the stored proc is executed only once a day. I think it's not really possible to guarantee that behaviour using PI methods only (regarding restart of PI for example).
Regards
Sven
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Monish,
For this you have to schedule the adapter.
/people/shabarish.vijayakumar/blog/2006/11/26/adapter-scheduling--hail-sp-19-
ATPs are not transportable so you have to maintain the settings at each system.
Regards
Ramesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.