This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
What is the table you are saying is getting updated by 4 hours?
LABOR
--- In MAXIMO@yahoogroups.com, Sarah Stewart <sarah@...> wrote:
>
> What is the table you are saying is getting updated by 4 hours?
>
What exactly is being updated in the table?
Are you positive you don't have any crontasks running?
Do you have any database jobs running?
Wes Williams
http://www.weswilliams.net
http://www.williamsconnell.com
________________________________
From: "hankinskeith@ymail.com" <keith.d.hankins@aexp.com>
To: MAXIMO@yahoogroups.com
Sent: Monday, January 23, 2012 11:42 AM
Subject: Re: [MAXIMO List] SQL Maximo Question
LABOR
--- In MAXIMO@yahoogroups.com, Sarah Stewart <sarah@...> wrote:
>
> What is the table you are saying is getting updated by 4 hours?
>
4 hours are being added to LABOR.REPORTEDHRS on the 1st of every month. I do have Crontasks running but none that do that. I don't konw how to check if any database jobs run... can you advise. I checked all my stored procedures but nothing there that was doing this... Any thoughts are greatly appreciated! Keith
--- In MAXIMO@yahoogroups.com, wwilliams@... wrote:
>
> What exactly is being updated in the table?Â
> Are you positive you don't have any crontasks running?
> Do you have any database jobs running?
>
> Â
> Wes Williams
>
>
> http://www.weswilliams.net
> http://www.williamsconnell.com
>
>
> ________________________________
> From: "hankinskeith@..." <keith.d.hankins@...>
> To: MAXIMO@yahoogroups.com
> Sent: Monday, January 23, 2012 11:42 AM
> Subject: Re: [MAXIMO List] SQL Maximo Question
>
>
> Â
> LABOR
>
> --- In MAXIMO@yahoogroups.com, Sarah Stewart <sarah@> wrote:
> >
> > What is the table you are saying is getting updated by 4 hours?
> >
>
>
>
>
>
>
Do you do daily restarts such that you could enable detailed logging just
before the 1st of the month for a short time?
Does this occur in a dev database where you could create a trigger to log
the source of the update?
Chris.
On Mon, Jan 23, 2012 at 3:18 PM, hankinskeith@ymail.com <
keith.d.hankins@aexp.com> wrote:
> **
>
>
> 4 hours are being added to LABOR.REPORTEDHRS on the 1st of every month. I
> do have Crontasks running but none that do that. I don't konw how to check
> if any database jobs run... can you advise. I checked all my stored
> procedures but nothing there that was doing this... Any thoughts are
> greatly appreciated! Keith
>
> --- In MAXIMO@yahoogroups.com, wwilliams@... wrote:
> >
> > What exactly is being updated in the table?�
> > Are you positive you don't have any crontasks running?
> > Do you have any database jobs running?
> >
> > �
> > Wes Williams
> >
> >
> > http://www.weswilliams.net
> > http://www.williamsconnell.com
> >
> >
> > ________________________________
> > From: "hankinskeith@..." <keith.d.hankins@...>
> > To: MAXIMO@yahoogroups.com
> > Sent: Monday, January 23, 2012 11:42 AM
> > Subject: Re: [MAXIMO List] SQL Maximo Question
> >
> >
> > �
> > LABOR
> >
> > --- In MAXIMO@yahoogroups.com, Sarah Stewart <sarah@> wrote:
> > >
> > > What is the table you are saying is getting updated by 4 hours?
> > >
> >
> >
> >
> >
> >
> >
>
>
>
If you are running on Oracle - check (or have your DBA check) to see what dbms_scheduler jobs are running.
Sign on as Maximo and run:select
owner,
job_name,
job_class,
enabled,
next_run_date,
repeat_interval
from
dba_scheduler_jobs
where
owner = decode(upper('&1'), 'ALL', owner, upper('&1'))
;
Find the one that is scheduled monthly and then trace it back from the job_name to the procedure and/or function. Once you are sure you have the correct job, disable it and 'voila' - added hours will not occur.
(I am only suggesting this as I think I am in the correct thread where you said you have already checked cron jobs and escalations.)
Pat Morrow
pmorrow8@yahoo.com
________________________________
From: "hankinskeith@ymail.com" <keith.d.hankins@aexp.com>
To: MAXIMO@yahoogroups.com
Sent: Monday, January 23, 2012 6:18 PM
Subject: Re: [MAXIMO List] SQL Maximo Question
4 hours are being added to LABOR.REPORTEDHRS on the 1st of every month. I do have Crontasks running but none that do that. I don't konw how to check if any database jobs run... can you advise. I checked all my stored procedures but nothing there that was doing this... Any thoughts are greatly appreciated! Keith
--- In MAXIMO@yahoogroups.com, wwilliams@... wrote:
>
> What exactly is being updated in the table?Â
> Are you positive you don't have any crontasks running?
> Do you have any database jobs running?
>
> Â
> Wes Williams
>
>
> http://www.weswilliams.net
> http://www.williamsconnell.com
>
>
> ________________________________
> From: "hankinskeith@..." <keith.d.hankins@...>
> To: MAXIMO@yahoogroups.com
> Sent: Monday, January 23, 2012 11:42 AM
> Subject: Re: [MAXIMO List] SQL Maximo Question
>
>
> Â
> LABOR
>
> --- In MAXIMO@yahoogroups.com, Sarah Stewart <sarah@> wrote:
> >
> > What is the table you are saying is getting updated by 4 hours?
> >
>
>
>
>
>
>
If you are running Oracle, you can look at this thread for a sample trigger that would capture info on the process updating the table.
You could even deny the transaction on the trigger, but that would just address the symptom and not the problem.
hth,
Jorge
--- In MAXIMO@yahoogroups.com, Pat Morrow <pmorrow8@...> wrote:
>
> If you are running on Oracle - check (or have your DBA check) to see what dbms_scheduler jobs are running.
> Â
> Sign on as Maximo and run:select
> Â Â owner,
> Â Â job_name,
> Â Â job_class,
> Â Â enabled,
> Â Â next_run_date,
> Â Â repeat_interval
> from
> Â Â dba_scheduler_jobs
> where
> Â Â owner = decode(upper('&1'), 'ALL', owner, upper('&1'))
> ;
> Â
> Find the one that is scheduled monthly and then trace it back from the job_name to the procedure and/or function. Once you are sure you have the correct job, disable it and 'voila' - added hours will not occur.
>
> (I am only suggesting this as I think I am in the correct thread where you said you have already checked cron jobs and escalations.)
>
> Pat Morrow
> pmorrow8@...
>
>
>
> ________________________________
> From: "hankinskeith@..." <keith.d.hankins@...>
> To: MAXIMO@yahoogroups.com
> Sent: Monday, January 23, 2012 6:18 PM
> Subject: Re: [MAXIMO List] SQL Maximo Question
>
>
> Â
> 4 hours are being added to LABOR.REPORTEDHRS on the 1st of every month. I do have Crontasks running but none that do that. I don't konw how to check if any database jobs run... can you advise. I checked all my stored procedures but nothing there that was doing this... Any thoughts are greatly appreciated! Keith
>
> --- In MAXIMO@yahoogroups.com, wwilliams@ wrote:
> >
> > What exactly is being updated in the table?ÃÂ
> > Are you positive you don't have any crontasks running?
> > Do you have any database jobs running?
> >
> > ÃÂ
> > Wes Williams
> >
> >
> > http://www.weswilliams.net
> > http://www.williamsconnell.com
> >
> >
> > ________________________________
> > From: "hankinskeith@" <keith.d.hankins@>
> > To: MAXIMO@yahoogroups.com
> > Sent: Monday, January 23, 2012 11:42 AM
> > Subject: Re: [MAXIMO List] SQL Maximo Question
> >
> >
> > ÃÂ
> > LABOR
> >
> > --- In MAXIMO@yahoogroups.com, Sarah Stewart <sarah@> wrote:
> > >
> > > What is the table you are saying is getting updated by 4 hours?
> > >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
>
Forgot the hread link...
https://forums.oracle.com/forums/thread.jspa?threadID=1022699
--- In MAXIMO@yahoogroups.com, "jcollado0" <jorge.collado@...> wrote:
>
> If you are running Oracle, you can look at this thread for a sample trigger that would capture info on the process updating the table.
> You could even deny the transaction on the trigger, but that would just address the symptom and not the problem.
>
> hth,
>
> Jorge
>
> --- In MAXIMO@yahoogroups.com, Pat Morrow <pmorrow8@> wrote:
> >
> > If you are running on Oracle - check (or have your DBA check) to see what dbms_scheduler jobs are running.
> > Â
> > Sign on as Maximo and run:select
> > Â Â owner,
> > Â Â job_name,
> > Â Â job_class,
> > Â Â enabled,
> > Â Â next_run_date,
> > Â Â repeat_interval
> > from
> > Â Â dba_scheduler_jobs
> > where
> > Â Â owner = decode(upper('&1'), 'ALL', owner, upper('&1'))
> > ;
> > Â
> > Find the one that is scheduled monthly and then trace it back from the job_name to the procedure and/or function. Once you are sure you have the correct job, disable it and 'voila' - added hours will not occur.
> >
> > (I am only suggesting this as I think I am in the correct thread where you said you have already checked cron jobs and escalations.)
> >
> > Pat Morrow
> > pmorrow8@
> >
> >
> >
> > ________________________________
> > From: "hankinskeith@" <keith.d.hankins@>
> > To: MAXIMO@yahoogroups.com
> > Sent: Monday, January 23, 2012 6:18 PM
> > Subject: Re: [MAXIMO List] SQL Maximo Question
> >
> >
> > Â
> > 4 hours are being added to LABOR.REPORTEDHRS on the 1st of every month. I do have Crontasks running but none that do that. I don't konw how to check if any database jobs run... can you advise. I checked all my stored procedures but nothing there that was doing this... Any thoughts are greatly appreciated! Keith
> >
> > --- In MAXIMO@yahoogroups.com, wwilliams@ wrote:
> > >
> > > What exactly is being updated in the table?ÃÂ
> > > Are you positive you don't have any crontasks running?
> > > Do you have any database jobs running?
> > >
> > > ÃÂ
> > > Wes Williams
> > >
> > >
> > > http://www.weswilliams.net
> > > http://www.williamsconnell.com
> > >
> > >
> > > ________________________________
> > > From: "hankinskeith@" <keith.d.hankins@>
> > > To: MAXIMO@yahoogroups.com
> > > Sent: Monday, January 23, 2012 11:42 AM
> > > Subject: Re: [MAXIMO List] SQL Maximo Question
> > >
> > >
> > > ÃÂ
> > > LABOR
> > >
> > > --- In MAXIMO@yahoogroups.com, Sarah Stewart <sarah@> wrote:
> > > >
> > > > What is the table you are saying is getting updated by 4 hours?
> > > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >
>