Hi oracle cummunity.
I have a scheduled job runnig every 10 minutes that collects data, exports them in xml, uploads the file via ftp an stores the file in an archive. But not every file is in fact uploaded via ftp even though the database logged "SUCCEEDED" for this step. To solve this problem I like at first to understand which conditions cause the scheduler to log "SUCCEEDED"?
The file is archived but not uploaded and there are no entries, not even a single line in the logfile of winscp (the software I use for the ftp connection) for this point of time.
The job is based on a chain of subprograms. The subprogram for the ftp-upload is of type "external script" and calls the winscp.exe on the same machine. This is the definition of the subprogram:
OWNER: xxx
PROGRAM_NAME : FTP_UPLOAD_SMB
PROGRAM_TYPE: EXTERNAL_SCRIPT
PROGRAM_ACTION: "E:\WinSCP\WinSCP.exe" /log="E:\WinSCP\log\WinSCP.log" /ini=nul /script="D:\Datentausch\bin_dir\FTP_SMB.txt"
NUMBER_OF_ARGUMENTS: 0
ENABLED: TRUE
COMMENTS:
DETACHED: FALSE
SCHEDULE_LIMIT:
PRIORITY: 3
WEIGHT: 1
MAX_RUNS:
MAX_FAILURES :
MAX_RUN_DURATION: