DSXchange

Hello,

I have a requirement where I need to search for fields from a given query and then based on the search if I find the searched fields then I need to run the DS job to update those fields.

So basically there are 10 jobs and based on the search I need to find specified fields and then select which jobs to run to update which fields

suryadev wrote:I have a requirement where I need to search for fields from a given query

you mean, need to trigger a job based on the query result ?

Yes, exactly

Need to trigger the correct job based on the query result search for fields


Thank you

Is the search numbers keep on grow / fixed and there won't be any changes?

There are some 10 queries which come as an alert, based on the alert/query which we see we need to do a search and pull the trigger for the correct job.

They are fixed queries 10 different kinds but fixed fields for each of them


Thank you

So, one server job to execute the query and store the result in its user status area, a Nested Condition activity to filter based on the value in the user status area with ten triggers to fire the ten Job activities. Maybe an Otherwise trigger as well.

Thank you!

Actually I need not run the query, only thing I need to check for the field names in the query and depending on the field names the jobs should be triggered.

Also I assume all these job activities and triggers will be in sequence job.

OK, use Nested Condition activity to search the query (use Index() function) and select the appropriate job to be run.

Yes, these are in a sequence.

Thanks very much!

I think that will help to do a sequence job and using the job activities to trigger other parallel jobs.