Re: DBMS Job vs C Daemon
dbms_job is the way to do since if you rollback the txn, then the job submission will also roll back hth connor --- Alroy Mascranghe [EMAIL PROTECTED] wrote: Several programs writes to a table. From that table a process has to be initiated. (Currently it is working on a trigger but this is causing locking problems). What would be the best way to do this - to read the table and start the process ? A PRO C daemon or a DBMS job ? What are the advantages and disadvantages of each ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alroy Mascranghe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBMS Job vs C Daemon
While I agree that dbms_job is the right way, we had lots of problems with dbms_job suddenly failing (i.e. it just stops working) in 9011 and 9012 versions of database. Finally it was something to do with job queue processes, with the help of OWS we fixed it. BUT, I still don't trust dbms_job on our 9i production db and hence all critical jobs are run by our close friend 'cron', it works!. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
Re: DBMS Job vs C Daemon
Possibly a candidate for Oracle Advanced Queueing? -Joe --- Connor McDonald [EMAIL PROTECTED] wrote: dbms_job is the way to do since if you rollback the txn, then the job submission will also roll back hth connor --- Alroy Mascranghe [EMAIL PROTECTED] wrote: Several programs writes to a table. From that table a process has to be initiated. (Currently it is working on a trigger but this is causing locking problems). What would be the best way to do this - to read the table and start the process ? A PRO C daemon or a DBMS job ? What are the advantages and disadvantages of each ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alroy Mascranghe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBMS Job vs C Daemon
I also agree, cron WORKS well ! The only thing I would add to cron jobs (shell scripts) is to use a semaphore file. e..g. --- semfile=/tmp/$0.RUNNING if [ -f $semfile ] ; then exit ; fi touch $semfile DO SOME SHELL STUFF rm $semfile exit --- This way no matter how frequent you run the job or how long it takes the job to run, it still works. I had a developer run a job every 5 mins but the job took 15 mins to run, so you can guess what begins to happen after a few days :-) Gene [EMAIL PROTECTED] 03/15/02 08:18AM While I agree that dbms_job is the right way, we had lots of problems with dbms_job suddenly failing (i.e. it just stops working) in 9011 and 9012 versions of database. Finally it was something to do with job queue processes, with the help of OWS we fixed it. BUT, I still don't trust dbms_job on our 9i production db and hence all critical jobs are run by our close friend 'cron', it works!. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBMS Job vs C Daemon
Raj, Was it some kind of patch for 9011 or 9012, which fixed dbms_job? Could you provide some details? It's very important for us, because we rely heavily on dbms_job (NT environment, looking to upgrade to 9i). Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 15, 2002 8:18 AM While I agree that dbms_job is the right way, we had lots of problems with dbms_job suddenly failing (i.e. it just stops working) in 9011 and 9012 versions of database. Finally it was something to do with job queue processes, with the help of OWS we fixed it. BUT, I still don't trust dbms_job on our 9i production db and hence all critical jobs are run by our close friend 'cron', it works!. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBMS Job vs C Daemon
..which is why we have a shell script that runs out of cron and checks on database jobs. Here is the SQL that we use to find jobs with problems: /* Check for broken jobs or jobs that have failed more than 8 times. */ /* Also check for jobs that should have run in the last day, but haven't. */ select job, failures, broken from dba_jobs where failures 8 or broken = 'Y' or sysdate - next_date 1 spool check_jobs.lis / spool off Some jobs have to run in the database, such as snapshot refreshes. Jay [EMAIL PROTECTED] 03/15/02 08:18AM While I agree that dbms_job is the right way, we had lots of problems with dbms_job suddenly failing (i.e. it just stops working) in 9011 and 9012 versions of database. Finally it was something to do with job queue processes, with the help of OWS we fixed it. BUT, I still don't trust dbms_job on our 9i production db and hence all critical jobs are run by our close friend 'cron', it works!. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBMS Job vs C Daemon
We don't let developers run the job but your idea is good about semaphore Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, March 15, 2002 8:59 AM To: Multiple recipients of list ORACLE-L I also agree, cron WORKS well ! The only thing I would add to cron jobs (shell scripts) is to use a semaphore file. e..g. --- semfile=/tmp/$0.RUNNING if [ -f $semfile ] ; then exit ; fi touch $semfile DO SOME SHELL STUFF rm $semfile exit --- This way no matter how frequent you run the job or how long it takes the job to run, it still works. I had a developer run a job every 5 mins but the job took 15 mins to run, so you can guess what begins to happen after a few days :-) Gene *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: DBMS Job vs C Daemon
In the past, I have seen databases not shutdown immediate b/c dbms_jobs were running, not sure if still true w/ 8i 9i? [EMAIL PROTECTED] 03/15/02 10:13AM ..which is why we have a shell script that runs out of cron and checks on database jobs. Here is the SQL that we use to find jobs with problems: /* Check for broken jobs or jobs that have failed more than 8 times. */ /* Also check for jobs that should have run in the last day, but haven't. */ select job, failures, broken from dba_jobs where failures 8 or broken = 'Y' or sysdate - next_date 1 spool check_jobs.lis / spool off Some jobs have to run in the database, such as snapshot refreshes. Jay [EMAIL PROTECTED] 03/15/02 08:18AM While I agree that dbms_job is the right way, we had lots of problems with dbms_job suddenly failing (i.e. it just stops working) in 9011 and 9012 versions of database. Finally it was something to do with job queue processes, with the help of OWS we fixed it. BUT, I still don't trust dbms_job on our 9i production db and hence all critical jobs are run by our close friend 'cron', it works!. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).