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.
All -
We have a process running behind the scenes (that I can't find) that is adding 4 hours on the first of each month to a specific table in Maximo. I'm trying to figure out where this might be being triggered from...
I've looked in the SQL Stored Procedures... Are there any other places where I could look to find this?
Greatly appreciate it!
Keith
What version of Maximo?
It could be a cron job or an escalation.
Pat Morrow
pmorrow8@yahoo.com
________________________________
From: "hankinskeith@ymail.com" <keith.d.hankins@aexp.com>
To: MAXIMO@yahoogroups.com
Sent: Thursday, January 19, 2012 3:06 PM
Subject: [MAXIMO List] SQL Maximo Question
All -
We have a process running behind the scenes (that I can't find) that is adding 4 hours on the first of each month to a specific table in Maximo. I'm trying to figure out where this might be being triggered from...
I've looked in the SQL Stored Procedures... Are there any other places where I could look to find this?
Greatly appreciate it!
Keith
6.2.4.... but I checked Escalations and Cron Jobs... and not there... any other ideas?
--- In MAXIMO@yahoogroups.com, Pat Morrow <pmorrow8@...> wrote:
>
> What version of Maximo?
> It could be a cron job or an escalation.
>
> Pat Morrow
> pmorrow8@...
>
>
>
> ________________________________
> From: "hankinskeith@..." <keith.d.hankins@...>
> To: MAXIMO@yahoogroups.com
> Sent: Thursday, January 19, 2012 3:06 PM
> Subject: [MAXIMO List] SQL Maximo Question
>
>
> Â
> All -
>
> We have a process running behind the scenes (that I can't find) that is adding 4 hours on the first of each month to a specific table in Maximo. I'm trying to figure out where this might be being triggered from...
>
> I've looked in the SQL Stored Procedures... Are there any other places where I could look to find this?
>
> Greatly appreciate it!
> Keith
>
>
>
>
>
>
Are you saying it always happens on a schedule rather than being event driven? How about a scheduled database job or a scheduled external process?
Does the changedate, chandedby etc get updated? As a last resort you could create a trigger in a test environment to track changes and log the source and timing of the update in a table.
On Jan 19, 2012, at 5:50 PM, "hankinskeith@ymail.com" <keith.d.hankins@aexp.com> wrote:
> 6.2.4.... but I checked Escalations and Cron Jobs... and not there... any other ideas?
>
> --- In MAXIMO@yahoogroups.com, Pat Morrow <pmorrow8@...> wrote:
> >
> > What version of Maximo?
> > It could be a cron job or an escalation.
> >
> > Pat Morrow
> > pmorrow8@...
> >
> >
> >
> > ________________________________
> > From: "hankinskeith@..." <keith.d.hankins@...>
> > To: MAXIMO@yahoogroups.com
> > Sent: Thursday, January 19, 2012 3:06 PM
> > Subject: [MAXIMO List] SQL Maximo Question
> >
> >
> > Â
> > All -
> >
> > We have a process running behind the scenes (that I can't find) that is adding 4 hours on the first of each month to a specific table in Maximo. I'm trying to figure out where this might be being triggered from...
> >
> > I've looked in the SQL Stored Procedures... Are there any other places where I could look to find this?
> >
> > Greatly appreciate it!
> > Keith
> >
> >
> >
> >
> >
> >
>
>
Where would I find a scheduled database job... or external process... big time novice here... Thank you in advance!
--- In MAXIMO@yahoogroups.com, Chris Lawless <lawlessc@...> wrote:
>
> Are you saying it always happens on a schedule rather than being event driven? How about a scheduled database job or a scheduled external process?
>
> Does the changedate, chandedby etc get updated? As a last resort you could create a trigger in a test environment to track changes and log the source and timing of the update in a table.
>
> On Jan 19, 2012, at 5:50 PM, "hankinskeith@..." <keith.d.hankins@...> wrote:
>
> > 6.2.4.... but I checked Escalations and Cron Jobs... and not there... any other ideas?
> >
> > --- In MAXIMO@yahoogroups.com, Pat Morrow <pmorrow8@> wrote:
> > >
> > > What version of Maximo?
> > > It could be a cron job or an escalation.
> > >
> > > Pat Morrow
> > > pmorrow8@
> > >
> > >
> > >
> > > ________________________________
> > > From: "hankinskeith@" <keith.d.hankins@>
> > > To: MAXIMO@yahoogroups.com
> > > Sent: Thursday, January 19, 2012 3:06 PM
> > > Subject: [MAXIMO List] SQL Maximo Question
> > >
> > >
> > > Ã
> > > All -
> > >
> > > We have a process running behind the scenes (that I can't find) that is adding 4 hours on the first of each month to a specific table in Maximo. I'm trying to figure out where this might be being triggered from...
> > >
> > > I've looked in the SQL Stored Procedures... Are there any other places where I could look to find this?
> > >
> > > Greatly appreciate it!
> > > Keith
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
>
>