Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.oracle.misc > #823

Re: dbms_job not running at sqlplus shell

Show all headers | View raw

On Saturday, March 29, 2014 1:53:14 AM UTC+8, ddf wrote:
> On Wednesday, March 26, 2014 9:44:10 PM UTC-6, Chek Ban Tan wrote:
> 
> > Hi,
> 
> > 
> 
> > 
> 
> > 
> 
> > I'm trying to run dbms_job at sqlplus shell but failed. In Toad i managed to run this at "Editor"->"Execute statement"
> 
> > 
> 
> > 
> 
> > 
> 
> > exec dbms_job.isubmit(1234, 'TEST;',SYSDATE,INTERVAL => 'SYSDATE+(2/24/60)');
> 
> > 
> 
> > /
> 
> > 
> 
> > successfully
> 
> > 
> 
> > 
> 
> > 
> 
> > But when i run
> 
> > 
> 
> > 
> 
> > 
> 
> >     [abc]$ sqlplus user/password @compile1.sql
> 
> > 
> 
> > 
> 
> > 
> 
> >     compile1.sql's content    
> 
> > 
> 
> >     spool compile.log;
> 
> > 
> 
> >     @try.sql
> 
> > 
> 
> >     spool off;
> 
> > 
> 
> > 
> 
> > 
> 
> > try.sql's content
> 
> > 
> 
> > 
> 
> > 
> 
> > exec dbms_job.isubmit(1234, 'TEST;',SYSDATE,INTERVAL => 'SYSDATE+(2/24/60)');
> 
> > 
> 
> > /
> 
> > 
> 
> > 
> 
> > 
> 
> > after runnning compile1.sql, this appears
> 
> > 
> 
> > 
> 
> > 
> 
> > [abc]$ sqlplus ESERV/ESERV @compile1.sql
> 
> > 
> 
> > 
> 
> > 
> 
> > SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 28 13:46:11 2014
> 
> > 
> 
> > 
> 
> > 
> 
> > Copyright (c) 1982, 2013, Oracle.  All rights reserved.
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > Connected to:
> 
> > 
> 
> > Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
> 
> > 
> 
> > With the Partitioning, OLAP, Data Mining and Real Application Testing options
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > and it stucked there forever. I did try to include begin ... end;
> 
> > 
> 
> > 
> 
> > 
> 
> > but still it doesn't succeed , kindly advise if you have any idea, thanks !
> 
> > 
> 
> > 
> 
> > 
> 
> > regards, Tan
> 
> 
> 
> 
> 
> Are you trying to run this in the same database?  If you got it to run from the SQL> prompt and are trying to get it to run again it won't, but it should have displayed an error that the job already exists.
> 
> 
> 
> 
> 
> What privileges does the ESERV user have?

Hi,
the sql run at command prompt is not stable , sometimes it can be executed but most of the time it hang there.
its not privilege issue.

The job does not have error.

Back to comp.databases.oracle.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

dbms_job not running at sqlplus shell Chek Ban Tan <chekban@gmail.com> - 2014-03-26 20:44 -0700
  Re: dbms_job not running at sqlplus shell ddf <oratune@msn.com> - 2014-03-28 10:53 -0700
    Re: dbms_job not running at sqlplus shell Chek Ban Tan <chekban@gmail.com> - 2014-03-31 03:42 -0700
      Re: dbms_job not running at sqlplus shell joel garry <joel-garry@home.com> - 2014-03-31 09:16 -0700
        Re: dbms_job not running at sqlplus shell Chek Ban Tan <chekban@gmail.com> - 2014-04-01 18:01 -0700
          Re: dbms_job not running at sqlplus shell ddf <oratune@msn.com> - 2014-04-02 10:34 -0700
          Re: dbms_job not running at sqlplus shell joel garry <joel-garry@home.com> - 2014-04-02 13:55 -0700

csiph-web