Re: [GENERAL] dbmsscheduler

2015-02-16 Thread Ramesh T
dbms_scheduler.create_job( job_name => 'DELETE_EMPTY_PART_NUMS' ,job_type => 'PLSQL_BLOCK') without pgagent or cron is not possible..? On Mon, Feb 9, 2015 at 11:35 AM, Pavel Stehule wrote: > Hi > > PostgreSQL doesn't have a dbms_scheduler. If you need it, you can use a > EnterpriseDB

Re: [GENERAL] dbmsscheduler

2015-02-14 Thread Adrian Klaver
On 02/14/2015 08:22 AM, Ramesh T wrote: dbms_scheduler.create_job( job_name => 'DELETE_EMPTY_PART_NUMS' ,job_type => 'PLSQL_BLOCK') without pgagent or cron is not possible..? It has already been stated a couple of times dbms_scheduler does not exist in the community version of Po

Re: [GENERAL] dbmsscheduler

2015-02-14 Thread Pavel Stehule
2015-02-14 17:22 GMT+01:00 Ramesh T : > dbms_scheduler.create_job( > job_name => 'DELETE_EMPTY_PART_NUMS' > ,job_type => 'PLSQL_BLOCK') > > without pgagent or cron is not possible..? > Not in PostgreSQL Regards Pavel Stehule > > On Mon, Feb 9, 2015 at 11:35 AM, Pavel Stehule > wro

Re: [GENERAL] dbmsscheduler

2015-02-08 Thread Pavel Stehule
Hi PostgreSQL doesn't have a dbms_scheduler. If you need it, you can use a EnterpriseDB - commercial fork with Oracle migration tools. There it is. You can use a scheduler pgAgent - https://github.com/postgres/pgagent http://www.pgadmin.org/docs/dev/pgagent.html Regards Pavel 2015-02-03 14:16

[GENERAL] dbmsscheduler

2015-02-08 Thread Ramesh T
hi, How to run dbms_scheduler.create_job in postgres and is it available postgres..? any help ,how to use in postgres..? FYI, i am using postgres 9.3 version thanks in advance,

Re: [GENERAL] dbmsscheduler

2015-02-03 Thread Adrian Klaver
On 02/03/2015 05:16 AM, Ramesh T wrote: hi, How to run dbms_scheduler.create_job in postgres and is it available postgres..? Postgres != Oracle. There is no dbms_scheduler in Postgres. You can use cron or pgAgent: http://www.pgadmin.org/docs/1.20/pgagent.html As has been pointed about