When I execute the job timesheet (postTimesheets.xql) using the parameter when=immediately, approved timesheets doesn't move to posted.
However, if I execute the job again, those approved timesheets will be posted.
In the same way, it works fine when i select "Scheduled" and "Immediately" for parameter "When", so its requiring a 2nd execution of the job....
Also I tried without success to configure the logs to see what is happening.
I enabled:
- Enables or disables action tracing (SQL Trace)
- Trace jobs
and All in Categories
How can i have more information about what the jobs is doing?
Thanks