Skip to Content
0
Jan 13, 2023 at 09:20 PM

BODS: decision variable on job status

208 Views

I have a job fetching many XML files in a directory and loading to target tables.

It's a scheduled job. I need to set up a mechanism, checking if files exist, then execute job or not.

That's first.

And if files exist, I need a variable to grab # of records ported from the XML files, and do a count.... if the count is Zero, the scheduler will send an alert by email.

I have the business logic, but does not know how to implement this in BODS.... any help is appreciated.