Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

Single copy execution 4 years 5 months ago #15001

  • Mick
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 0
I'm trying to execute a single copy of the package one at a time. This is to ensure efficiency of the package that is being executed every 2 minutes that will take more than of the interval to complete.

Mick

Please Log in or Create an account to join the conversation.

Single copy execution 4 years 5 months ago #15002

Thanks for you message.

We can do this using SQL Data Check Action because it uses SQL scripts to check data in the database. For example the following code can expressed:

Select count(*) from table


Execution will be successful if the value of first field of lookup
Execution will fail if the value of first field of lookup query equals to 0 or less than 0 or field is not of numeric value.

Using the same approach we can query QUEUE and QUEUE_ACTIONS tables

Select Count(*) as RC from
( select OBJECT_ID from QUE WHERE STATUS='R' and OBJECT_ID=3924
union all
select OBJECT_ID from QUEUE_ACTIONS WHERE STATUS='R' and OBJECT_ID=3924
)



Note:
3924 is a Package ID
Status = R means Running

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 138 guests and no members online