Page 1 of 1

Scheduler for SEQUENCE Job

Posted: Mon Aug 11, 2014 6:12 am
by 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

Posted: Mon Aug 11, 2014 7:37 am
by 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.

Posted: Mon Aug 11, 2014 10:16 am
by 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. :wink: