Scheduler for SEQUENCE Job

[imfarhan]

Dear All,
I've a simple SEQUENCE job 'x' which runs successfully when I run manually but when I schedule the 'x' SEQUENCE job the Status keep showing 'Running' but doesn't do anything the Log show like:

Code: Select all

SHFT_Sequence: Set NLS locale to US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH

One of the first thing in my 'x' SEQUENCE job is to run the Batch file
The batch file simply copy file from FTP server into the local server.

Appreciate your help.
Kind regards,
F

[chulett]

Typically that would be because your batch file has stopped to ask a question and is waiting for an answer. Could be a simple yes/no or could be something like a prompt for a password. And this probably because the scheduled job runs under a different userid.

[chulett]

Let us know what you find out. To be honest, I'm not really following your solution but perhaps it's not important that I do if you've got something that works for you now.