Re: Scheduling jobs

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Poul Møller Hansen
> Sent: 17 February 2006 13:20
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Scheduling jobs
>
>
> >The schema needs to be in your maintenance DB (ie. The one
> pgAdmin initially connects to). My guess is that you put it
> someplace else.
> >
> >
> >
> ahh, now it works :)
>
> How can I get with of the pgagent schema in the other database again ?
> I get the message "Cannot drop system Schema pgagent"

Ahh, that you be pgAdmin protecting you from yourself :-)

Try the following in a Query Tool (in the appropriate database):

DROP SCHEMA pgagent CASCADE;

Regards, Dave.