Action-Orders

MirkoW · Post by **MirkoW** » Tue Aug 12, 2008 7:00 am

Hi,

i have Create a Action profile with Alert-Actions because i need 3 SQL-Querys and this Querys need a right order for running.

The first Script are an Insertion-Script, the second a delete and the third an optimization script for SQL

But i dont have any Sort or Order-Options for Alerts.

By the way: it is able to get a result from these sql scripts on a SQL-Query Action? by Mail etc ? because i can only get Results by QuickLog

KS-Soft · Post by **KS-Soft** » Tue Aug 12, 2008 7:10 am

i have Create a Action profile with Alert-Actions because i need 3 SQL-Querys and this Querys need a right order for running.
The first Script are an Insertion-Script, the second a delete and the third an optimization script for SQL

May be its better to use single stored procedure?

But i dont have any Sort or Order-Options for Alerts

If you are using the same start condition for all actions (e.g. start action after 2nd consecutive failure) then actions will be started in creation order. If you need to change order for action1 and action2, you need to remove action1 and recreate it again.

By the way: it is able to get a result from these sql scripts on a SQL-Query Action?

Tests return results, actions do not. May be you need a test item?

Regards
Alex

MirkoW · Post by **MirkoW** » Tue Aug 12, 2008 7:58 am

Hi,
thanks, i have created a test item.