You should be able to set up a DTS package that runs the VFP program. Then you can schedule the DTS package to run at certain times with SQL Agent.

>Hi Sergey,
>
>I have tried to run it in the Windows scheduler and it works fine, but I would much prefer to do it with SQL Agent because it looks like it would be possible to run a series of programs in steps.
>
>Mine depends on a couple of others to run sucessfully and another few should run after my exe has completed.
>
>Like I wrote earlier, I've tried a cmd file with
>
>cd\MyDir
>MyApp.exe
>
>but that fails.
>
>
>
>>>To take the last one first:
>>>
>>>I was told that it's possible in DB2 to have a datetime field in a table and format the display value as YYYY.MM or YYYY.WW or whatever else one may desire within the context of a datetime.
>>>
>>>Additionally, when using the field in a join operation, DB2 would use the format and actually link on the YYYY.MM part only.
>>>
>>>Offhand I could find nothing in the documentation to indicate a similar feature in SQL Server 2K, so I assume it's not available?
>>
>>
>>There's no such feature in Sql Server. You've to use Convert(), Cast() or Datediff() functions depending on the type of comparison.
>>
>>>
>>The other one is about SQL Agent:
>>>
>>>I'd like to run a VFP program at regular intervals using SQL Agent.
>>>The VFP program expects to start in it's installation directory (varies), where it will read stuff from an ini file.
>>>I have tried several approaches, (batch cmd a.s.o.), so far without any luck.
>>>
>>>Could somebody please post an example of how it's done?
>>
>>You can use Windows Task Scheduler to run VFP program at regular intervals.