dbmsscheduler

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 before, if you want Oracle compatibility take
a look at:

http://www.enterprisedb.com/.

Just a heads up, their Oracle compatibility layer is a for pay add on.

any help ,how to use in postgres..?
FYI, i am using postgres 9.3 version

thanks in advance,

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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 GMT+01:00 Ramesh T <rameshparnanditech@gmail.com>:

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 <pavel.stehule@gmail.com>
wrote:

2015-02-14 17:22 GMT+01:00 Ramesh T <rameshparnanditech@gmail.com>:

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 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 Postgres.

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general