I scheduled a data extraction with an Xquery query on ML 8.0.6 using the "scheduler tasks".
My Xquery query (this query works if I copy/paste it in the ML web console and I get a file available on AWS S3):
xdmp:save("s3://XX.csv",let $nl := " "
return
document {
for $book in collection("books")/books
return (root($book)/bookId||","||
$optin/updatedDate||$nl
)
})
My scheduled task :
- Task enabled : yes
- Task path : /home/bob/extraction.xqy
- task root : /
- task type: hourly
- task period : 1
- task start time: 8 past the hour
- task database : mydatabase
- task modules : file system
- task user : admin
- task host: XX
- task priority : higher
Unfortunately, my script is not executed because no file is generated on AWS S3 (the storage used)and I do not have any logs.
Any idea to : 1/debug a job in the scheduler task? 2/ See the job running at the expected time ?
Thanks, Romain.