Home » RDBMS Server » Enterprise Manager » Executing stored procedures via OEM scheduled jobs
Executing stored procedures via OEM scheduled jobs [message #68125] Thu, 21 November 2002 14:44 Go to next message
Eddy Confer
Messages: 17
Registered: January 2002
Junior Member
My database contains stored procedures to update fields in various tables. Typically these stored procedures are executed within a VB application. I would like to create a job in OEM to fire off the stored procedures at a scheduled time. Is this possible? Would I use Run DBA Script or Run SQL *Plus Script? Can someone get me started?

Report message to a moderator

Re: Executing stored procedures via OEM scheduled jobs [message #68126 is a reply to message #68125] Fri, 22 November 2002 06:19 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
u can run it as dba script
or
submit as a job in JOB panel

Report message to a moderator

Previous Topic: Temporary Tablespace Not getting updated.
Next Topic: disconnect from remote database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 23:45:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.