Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: table which keep tracks of chron jobs history
swapna.marri_at_gmail.com wrote:
> Hi,
>
> We schedule the pl/sql procedures and queries through cron jobs.
>
> for example if you run any .sql script(contains 2 to 3 actions i.e
> queries,procedures ),it will produce an output saying "procedure ran
> sucessfully"....."23456 rows inserted succesfully" etc etc..
>
> the cron jobs will produce the logfiles where we can check whether that
> particular job ran successfully or not.
>
> The same thing i want to see in the form of oracle table which keep
> track of job name,when the job has ran succesfully,at what time etc
> etc..
>
> so that we will have the history of the jobs in a table having
> information like at what time what all jobs has ran successfully.
>
> how can we pass this information to a oracle table..
>
> I know that the errors can be collected by making use of exceptions
> where we will make use of procedure.
>
> how about the succesful commands????
search asktom.oracle.com for external tables.
jg
-- @home.com is bogus. Happy Endangered Species Day! http://www.signonsandiego.com/news/metro/20060510-9999-7m10day.htmlReceived on Thu May 11 2006 - 16:39:05 CDT