CommServe DB query
WHERE jobstatus = 'Failed to Start'
and backuplevel = 'Synthetic Full'
and iDataAgent = 'Virtual Server'
order by jobid desc ;
I was this list to contain only the jobs from last 24 hours, how to add the time range in this sql query.
Best answer by Jos MeijerView original
Jos, Meier you might know this.
What’s the simplest way to achieve conditional and statements in a query.
google fails me.
something like this?
Honestly I have to try it to be sure.
i want to use a check box to modify a where clause in a workflow.
even if it doesnt work this gives me a good idea what to try next. Thanks