APPOINTMENT AUTO COMPLETE

Hi,

Does anyone know of a way to stop MS CRM from automatically completing
appointments?

When I get back in the office having attended an appointment I want to
be able to add necessary comments and close the appointment manually.
At the moment I come back into the office and my appointments are
already in my closed activities list!

Thanks in advance
Lee

John
Sat Jul 31 20:32:30 CDT 2004

is this a clue?

Microsoft SQL Server has a database maintenance task that automatically
closes past appointments at a scheduled time each day. The default time is
12am.

MORE INFORMATION

Appointments that have a scheduled end date in the past are automatically
closed through the execution of a SQL job entitled 'Close Past
Appointments'.

You can view the SQL job by going to Start | Programs | Microsoft SQL Server
| Enterprise Manager. Expand on you SQL Server, expand on Management, expand
on SQL Server Agent, and click on Jobs. You can then view the Close Past
Appointments job. To view the job's properties, right-click on the job and
choose 'Properties'.

--
John O'Donnell
Microsoft CRM MVP


"Lee" <l.hargrave@btinternet.com> wrote in message
news:394322d8.0407300624.44d5158@posting.google.com...
> Hi,
>
> Does anyone know of a way to stop MS CRM from automatically completing
> appointments?
>
> When I get back in the office having attended an appointment I want to
> be able to add necessary comments and close the appointment manually.
> At the moment I come back into the office and my appointments are
> already in my closed activities list!
>
> Thanks in advance
> Lee

l
Sun Aug 01 09:03:23 CDT 2004

John,
Thanks for your response.

Is it possible to disable the SQL job entitled 'Close Past
Appointments'?

Thanks
Lee


"John O'Donnell" <csharpconsulting@nospam-hotmail.com-nospam> wrote in message news:<uz9Srd2dEHA.2520@TK2MSFTNGP12.phx.gbl>...
> is this a clue?
>
> Microsoft SQL Server has a database maintenance task that automatically
> closes past appointments at a scheduled time each day. The default time is
> 12am.
>
> MORE INFORMATION
>
> Appointments that have a scheduled end date in the past are automatically
> closed through the execution of a SQL job entitled 'Close Past
> Appointments'.
>
> You can view the SQL job by going to Start | Programs | Microsoft SQL Server
> | Enterprise Manager. Expand on you SQL Server, expand on Management, expand
> on SQL Server Agent, and click on Jobs. You can then view the Close Past
> Appointments job. To view the job's properties, right-click on the job and
> choose 'Properties'.
>
> --
> John O'Donnell
> Microsoft CRM MVP
>
>
> "Lee" <l.hargrave@btinternet.com> wrote in message
> news:394322d8.0407300624.44d5158@posting.google.com...
> > Hi,
> >
> > Does anyone know of a way to stop MS CRM from automatically completing
> > appointments?
> >
> > When I get back in the office having attended an appointment I want to
> > be able to add necessary comments and close the appointment manually.
> > At the moment I come back into the office and my appointments are
> > already in my closed activities list!
> >
> > Thanks in advance
> > Lee

SiEBEN
Mon Aug 02 06:48:16 CDT 2004

Hello Lee,
I am trying to work it out through the Activity Base table where the
activities are stored marked as Closed, Active or Canceled...

Anyway, I am having exactly the same trouble with you. Please, if you try to
disable the SQL job and it works, or if you find another workaround, update
the newsgroup.

Thank you,

Elena

"Lee" <l.hargrave@btinternet.com> wrote in message
news:394322d8.0408010603.1b19b70d@posting.google.com...
> John,
> Thanks for your response.
>
> Is it possible to disable the SQL job entitled 'Close Past
> Appointments'?
>
> Thanks
> Lee
>
>
> "John O'Donnell" <csharpconsulting@nospam-hotmail.com-nospam> wrote in
message news:<uz9Srd2dEHA.2520@TK2MSFTNGP12.phx.gbl>...
> > is this a clue?
> >
> > Microsoft SQL Server has a database maintenance task that automatically
> > closes past appointments at a scheduled time each day. The default time
is
> > 12am.
> >
> > MORE INFORMATION
> >
> > Appointments that have a scheduled end date in the past are
automatically
> > closed through the execution of a SQL job entitled 'Close Past
> > Appointments'.
> >
> > You can view the SQL job by going to Start | Programs | Microsoft SQL
Server
> > | Enterprise Manager. Expand on you SQL Server, expand on Management,
expand
> > on SQL Server Agent, and click on Jobs. You can then view the Close Past
> > Appointments job. To view the job's properties, right-click on the job
and
> > choose 'Properties'.
> >
> > --
> > John O'Donnell
> > Microsoft CRM MVP
> >
> >
> > "Lee" <l.hargrave@btinternet.com> wrote in message
> > news:394322d8.0407300624.44d5158@posting.google.com...
> > > Hi,
> > >
> > > Does anyone know of a way to stop MS CRM from automatically completing
> > > appointments?
> > >
> > > When I get back in the office having attended an appointment I want to
> > > be able to add necessary comments and close the appointment manually.
> > > At the moment I come back into the office and my appointments are
> > > already in my closed activities list!
> > >
> > > Thanks in advance
> > > Lee

Matt
Mon Aug 02 10:51:27 CDT 2004

Lee,

Yes it is possible. One thing you might consider is to change the procedure
that is used by this job to alter the criteria it uses to auto-close the
appointments. You might find it equally bothersome to have them all stay open.

The procedure it runs is p_ClosePastAppointments.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On 1 Aug 2004 07:03:23 -0700, l.hargrave@btinternet.com (Lee) wrote:

John,
Thanks for your response.

Is it possible to disable the SQL job entitled 'Close Past
Appointments'?

Thanks
Lee


"John O'Donnell" <csharpconsulting@nospam-hotmail.com-nospam> wrote in message
news:<uz9Srd2dEHA.2520@TK2MSFTNGP12.phx.gbl>...
> is this a clue?
>
> Microsoft SQL Server has a database maintenance task that automatically
> closes past appointments at a scheduled time each day. The default time is
> 12am.
>
> MORE INFORMATION
>
> Appointments that have a scheduled end date in the past are automatically
> closed through the execution of a SQL job entitled 'Close Past
> Appointments'.
>
> You can view the SQL job by going to Start | Programs | Microsoft SQL Server
> | Enterprise Manager. Expand on you SQL Server, expand on Management, expand
> on SQL Server Agent, and click on Jobs. You can then view the Close Past
> Appointments job. To view the job's properties, right-click on the job and
> choose 'Properties'.
>
> --
> John O'Donnell
> Microsoft CRM MVP
>
>
> "Lee" <l.hargrave@btinternet.com> wrote in message
> news:394322d8.0407300624.44d5158@posting.google.com...
> > Hi,
> >
> > Does anyone know of a way to stop MS CRM from automatically completing
> > appointments?
> >
> > When I get back in the office having attended an appointment I want to
> > be able to add necessary comments and close the appointment manually.
> > At the moment I come back into the office and my appointments are
> > already in my closed activities list!
> >
> > Thanks in advance
> > Lee

l
Tue Aug 03 02:55:17 CDT 2004

Matt,

Can you tell me how I disable the SQL joB?

I agree that the best solution would be to change the procedure that
is used by this job to alter the criteria it uses to auto-close the
appointments. However, we do not have the technical knowledge to do
this safely.

Thanks
Lee


Matt Parks <mattp65@RemoveToX_XYahoo.com> wrote in message news:<7dosg0pvv92o7bjchhui48j9f5li1rvep0@4ax.com>...
> Lee,
>
> Yes it is possible. One thing you might consider is to change the procedure
> that is used by this job to alter the criteria it uses to auto-close the
> appointments. You might find it equally bothersome to have them all stay open.
>
> The procedure it runs is p_ClosePastAppointments.
>
> Matt Parks
> MVP - Microsoft CRM
>
> ----------------------------------------
> ----------------------------------------
> On 1 Aug 2004 07:03:23 -0700, l.hargrave@btinternet.com (Lee) wrote:
>
> John,
> Thanks for your response.
>
> Is it possible to disable the SQL job entitled 'Close Past
> Appointments'?
>
> Thanks
> Lee
>
>
> "John O'Donnell" <csharpconsulting@nospam-hotmail.com-nospam> wrote in message
> news:<uz9Srd2dEHA.2520@TK2MSFTNGP12.phx.gbl>...
> > is this a clue?
> >
> > Microsoft SQL Server has a database maintenance task that automatically
> > closes past appointments at a scheduled time each day. The default time is
> > 12am.
> >
> > MORE INFORMATION
> >
> > Appointments that have a scheduled end date in the past are automatically
> > closed through the execution of a SQL job entitled 'Close Past
> > Appointments'.
> >
> > You can view the SQL job by going to Start | Programs | Microsoft SQL Server
> > | Enterprise Manager. Expand on you SQL Server, expand on Management, expand
> > on SQL Server Agent, and click on Jobs. You can then view the Close Past
> > Appointments job. To view the job's properties, right-click on the job and
> > choose 'Properties'.
> >
> > --
> > John O'Donnell
> > Microsoft CRM MVP
> >
> >
> > "Lee" <l.hargrave@btinternet.com> wrote in message
> > news:394322d8.0407300624.44d5158@posting.google.com...
> > > Hi,
> > >
> > > Does anyone know of a way to stop MS CRM from automatically completing
> > > appointments?
> > >
> > > When I get back in the office having attended an appointment I want to
> > > be able to add necessary comments and close the appointment manually.
> > > At the moment I come back into the office and my appointments are
> > > already in my closed activities list!
> > >
> > > Thanks in advance
> > > Lee

Matt
Tue Aug 03 14:03:34 CDT 2004

Lee,

You can disable the job via Enterprise Manager under the Management node, expand
out the SQL Agent and look at the jobs.

I will warn you though, if you are lacking the technical knowledge, I would be
very careful doing this to make sure you do the right job. Changing the wrong
job can have impact as there are other processes that could be running that you
need.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On 3 Aug 2004 00:55:17 -0700, l.hargrave@btinternet.com (Lee) wrote:

Matt,

Can you tell me how I disable the SQL joB?

I agree that the best solution would be to change the procedure that
is used by this job to alter the criteria it uses to auto-close the
appointments. However, we do not have the technical knowledge to do
this safely.

Thanks
Lee


Matt Parks <mattp65@RemoveToX_XYahoo.com> wrote in message
news:<7dosg0pvv92o7bjchhui48j9f5li1rvep0@4ax.com>...
> Lee,
>
> Yes it is possible. One thing you might consider is to change the procedure
> that is used by this job to alter the criteria it uses to auto-close the
> appointments. You might find it equally bothersome to have them all stay open.
>
> The procedure it runs is p_ClosePastAppointments.
>
> Matt Parks
> MVP - Microsoft CRM
>
> ----------------------------------------
> ----------------------------------------
> On 1 Aug 2004 07:03:23 -0700, l.hargrave@btinternet.com (Lee) wrote:
>
> John,
> Thanks for your response.
>
> Is it possible to disable the SQL job entitled 'Close Past
> Appointments'?
>
> Thanks
> Lee
>
>
> "John O'Donnell" <csharpconsulting@nospam-hotmail.com-nospam> wrote in message
> news:<uz9Srd2dEHA.2520@TK2MSFTNGP12.phx.gbl>...
> > is this a clue?
> >
> > Microsoft SQL Server has a database maintenance task that automatically
> > closes past appointments at a scheduled time each day. The default time is
> > 12am.
> >
> > MORE INFORMATION
> >
> > Appointments that have a scheduled end date in the past are automatically
> > closed through the execution of a SQL job entitled 'Close Past
> > Appointments'.
> >
> > You can view the SQL job by going to Start | Programs | Microsoft SQL Server
> > | Enterprise Manager. Expand on you SQL Server, expand on Management, expand
> > on SQL Server Agent, and click on Jobs. You can then view the Close Past
> > Appointments job. To view the job's properties, right-click on the job and
> > choose 'Properties'.
> >
> > --
> > John O'Donnell
> > Microsoft CRM MVP
> >
> >
> > "Lee" <l.hargrave@btinternet.com> wrote in message
> > news:394322d8.0407300624.44d5158@posting.google.com...
> > > Hi,
> > >
> > > Does anyone know of a way to stop MS CRM from automatically completing
> > > appointments?
> > >
> > > When I get back in the office having attended an appointment I want to
> > > be able to add necessary comments and close the appointment manually.
> > > At the moment I come back into the office and my appointments are
> > > already in my closed activities list!
> > >
> > > Thanks in advance
> > > Lee