Automation of Deletion of records on the daily basis

Поиск
Список
Период
Сортировка
От Mahendra Nath
Тема Automation of Deletion of records on the daily basis
Дата
Msg-id 3CCA670D.1AD34F8D@dxb-co.ae.dhl.com
обсуждение исходный текст
Список pgsql-novice
Hi,

This is Mahendra,

Could you please help me out in this doubt

I need to delete records from MSaccess database table
automatically on the daily basis(everyday)

I have a scheduler which calls the batch file and
inside batch file I'm calling database
with a autoexec macro.

(To delete all the records whos date is more than 90 days from current
date)
In Macro I have selected RUNSQL
and sql=delete from table_name where req_date <90

 this is running fine but asking for do you wish to delete so many
records
Yes or no.. and getting struck in automation process.

So can u help me out what is the solution or alternate for this

Thanks & Rgds
Mahendra


В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Strange behaviour
Следующее
От: Wim
Дата:
Сообщение: Problems with compiling postgres 7.2.1 on HPUX