>>>Hi,
>>>
>>>I had my application written using VFP 5a. As this program need to run only at a specific time of the day under the NT server. I use the NT AT command to set it to run at a fix time. I had enable the scheduler service under the NT server.
>>>
>>>However, my batch file didn't run (it should change to the application folder, then run it)when the time is right.
>>>What is wrong, please advise me on this area. Thank you.
>>>
>>>My batch file content, srun.cmd
>>>
>>>c:
>>>cd\test
>>>test AUTO
>>>
>>>
>>>My AT command :
>>>
>>>AT 15:15 'c:\test\srun.cmd'
>>
>>Hello Virusim,
>> Look in the NT help file under "AT Command", "Security and the AT Command". >You probably have a permissions problem. HTH.
>
>Hi,
>
>Thank for your advise. However, I found out from
www.NTfaq.com that upon logout, the AT will run any program that we specify using it local account and any mapping that I had will not be there too. Therefore, my application will had problem as I need the mapped drive to get the data for importing into my SQL server. Please advise me on this issues. Thank you
You could run the AT command from your server instead of the workstation. If you are using SQL Server, why not use the built-in job scheduler? I don't know which version of SQL you're using, but if it's 7.0, look at using the Data Transformation Service for moving your data. It is a very powerful utility. If you're using 6.5, the Task Scheduler works well but is more difficult to learn. Regardless of which method you use, permissions between the scheduler and the scheduled applications still have to be established and maintained.
Bob Tracy
Never engage in a battle of wits if you're only half armed.