Hi,

I want a session to run as a part of job based on a particular condition.

Is this possible, if yes then how shall I go forward?

Example: I want to run an update session to get the data from the outside source, but based on the condition that in the table tfgld100 status of all the batches should be Finalized.

PS: The update session has nothing to do with tfgld100 table. It is based on different tables of finance.

Thanks,
KS

Is this update session a customized one?

Then you can put this condition in your customized session itself and put that session in the job.

Else, you can write an AFS for this session and put the condition in that session.

Regards,
Kaustubh

Hi,
Thanks for the quick update.

But this is not the customized session. and when you say that write an AFS, then within the AFS we need to give the job name also, but that job has more than 10 sessions which run when the job runs.

So, that way, it will affect all the sessions associated with the job.

You have got me wrong...:confused:

What I mean is you can put the session into AFS and put the AFS into the job. :)

Regards,
Kaustubh

You mean to say I should go like this:

1. write an AFS which will include the required condition.
2. This AFS will also have the session to be run in job.
3. The AFS session, I would put into the job.


Am I right?

Thats right...:)

You can always custmoize session and check if the condition is true if in job. This is not a major customization.