"Krishnakanth" <Kr**********@discussions.microsoft.comwrote in message
news:12**********************************@microsof t.com...
>I have got a requirement as follows.
I am having a table RCBL_ERROR in a database in DB2.
I need to create a batch file, which has to extract the rows from this
table
and write those extracted records to a text file.
And that text file needs to be placed in the folders ORD and BKUP.
The text file name should be "error_report_09302008.txt"
The error report name will be like error_report_<date>.
Since this is a batch job, can we schedule this batch job to run daily at
1
AM PST.
is it possible ?
Sure you can do it. You can write a VB.Net or C#.NET Windows desktop
solution that has nothing on the form no Win controls on the Win from,
minimize the form so it's not seen.
You can run the program-name.exe in a batch file. You can even check the
return-code that the program would return to the batch, and process
accordingly based on the return-code.
You can also just make a Console Application that starts and ends itself
with no user interaction and just schedule the exe to run. You can do the
same with the Windows solution up a above there too and not even need a
batch file, just schedule the exe.