schtasks to call batch file.

[am_shraddha]

hello,

i have a .bat file that executes the .sql. This batch files executes sucessfully if executed at the commnad prompt and gives the required result.

However when I schedule this .bat file to execute through the schedular using the schtasks command, it doesnt work.
can anybody pls help me on this. i need to schdule this batch file at a regual interval.


batch file looks something like this :
@echo off
for /f variable_name in ('sql command with all required parameters') do (
something
)
remaining_code