TM1 Forum

Dear All,

There is a process, datasource is database, the TM1 process would be executed every day, but when an exception occurs at the database jobs, the data record in the database table would be 0, and this time, the process is not allowed to execute.

how can i do this?

tks

You could use 2 processes: your current process, but before that process you execute a different process that loops through the same database query.
If content is found, proceed to the next process and execute it, if not abort. This might increase your time to execute the process since you will run the query twice (possibly).

Or - if your security policies allow - you could use a first process to push the data into a file in the data directory, then use that as a source for a second process if and only if records were returned.