enabling and disabling of agents question

on the properties page for an agent (I referring mainly to snapshot and
merge agents), on the general tab there is an 'enable' check box. Then on
the schedule tab there is also an 'enable' checkbox for the shedule.
If the enable checkbox on the general tab is not checked (disabled) but the
enable checkbox on the schedule is checked (enabled) will the agent run?
The reason I ask is that my merge agent was running even though I'm looking
at the enable check box and it is not checked? The only thing I can think
of is that I unchecked 'enable' while the agent was currently running..
maybe I did not stop it first.. could that be the explanation?
any info is appreciated. thanks.
DJC,
yes - you need to stop synchronizing to stop the job, and disabling it just
sets the property without stopping it. 'Start Synchronizing' and 'Stop
Synchronizing' are actually independant of this property though.
HTH,
Paul Ibison
|||that helps very much. Thank you again Paul.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23Ccmp%23wUEHA.3692@.TK2MSFTNGP09.phx.gbl...
> DJC,
> yes - you need to stop synchronizing to stop the job, and disabling it
just
> sets the property without stopping it. 'Start Synchronizing' and 'Stop
> Synchronizing' are actually independant of this property though.
> HTH,
> Paul Ibison
>

EMs Database Space Available Wrong

Anyone ever see a case where the Space Available number
reported in Enterprise Manager's General Database
Properties tab is wrong?
My database has the following characteristics:
-1- Has a Daily Backup Maintenance plan (no other
optimizations such as data reorg and such)
-2- Simple Recovery Model
-3- Auto Update Statistics = on
-4- Auto Create Statistics = on
-5- All other settings on Options tab = off
I went and increased the data file to 500 MB larger than
the current size and still do not see Available space
increase. It's sitting at 0.
Any explanations/assistance would be greatly
appreciated. Thanks, Bob
See DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Bob Albert" <bob.albert@.quest.com> wrote in message
news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
> My database has the following characteristics:
> -1- Has a Daily Backup Maintenance plan (no other
> optimizations such as data reorg and such)
> -2- Simple Recovery Model
> -3- Auto Update Statistics = on
> -4- Auto Create Statistics = on
> -5- All other settings on Options tab = off
> I went and increased the data file to 500 MB larger than
> the current size and still do not see Available space
> increase. It's sitting at 0.
> Any explanations/assistance would be greatly
> appreciated. Thanks, Bob
|||That's worked! Thank you so much!
Bob
>--Original Message--
>See DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
>--
>Vyas, MVP (SQL Server)
>SQL Server Articles and Code Samples @.
http://vyaskn.tripod.com/[vbcol=seagreen]
>
>"Bob Albert" <bob.albert@.quest.com> wrote in message
>news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
than
>
>.
>
|||> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
Yes, Enterprise Manager is often wrong because it relies on cached data for
a lot of its values. If you want a reliable space used report, use EXEC
sp_spaceused in Query Analyzer, not Enterprise Manager. Also check into the
@.updateusage parameter. (sp_spaceused is well documented in Books Online).
Aaron
|||Narayana had the answer. I was actuallly originally
using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
the database in question and it corrected the issue.
Thanks for responding so quickly! Bob
>--Original Message--
>Yes, Enterprise Manager is often wrong because it relies
on cached data for
>a lot of its values. If you want a reliable space used
report, use EXEC
>sp_spaceused in Query Analyzer, not Enterprise Manager.
Also check into the
>@.updateusage parameter. (sp_spaceused is well
documented in Books Online).
>Aaron
>
>.
>
|||> using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
> the database in question and it corrected the issue.
Note that if you want to use the EM view, you're going to have to open QA to
execute the DBCC command every time anyway. Why not just use QA, then you
can save a script with EXEC sp_spaceused withthe @.updateusage parameter and
never wonder if your space used report is really up to date.

EMs Database Space Available Wrong

Anyone ever see a case where the Space Available number
reported in Enterprise Manager's General Database
Properties tab is wrong?
My database has the following characteristics:
-1- Has a Daily Backup Maintenance plan (no other
optimizations such as data reorg and such)
-2- Simple Recovery Model
-3- Auto Update Statistics = on
-4- Auto Create Statistics = on
-5- All other settings on Options tab = off
I went and increased the data file to 500 MB larger than
the current size and still do not see Available space
increase. It's sitting at 0.
Any explanations/assistance would be greatly
appreciated. Thanks, Bob
See DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Bob Albert" <bob.albert@.quest.com> wrote in message
news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
> My database has the following characteristics:
> -1- Has a Daily Backup Maintenance plan (no other
> optimizations such as data reorg and such)
> -2- Simple Recovery Model
> -3- Auto Update Statistics = on
> -4- Auto Create Statistics = on
> -5- All other settings on Options tab = off
> I went and increased the data file to 500 MB larger than
> the current size and still do not see Available space
> increase. It's sitting at 0.
> Any explanations/assistance would be greatly
> appreciated. Thanks, Bob
|||That's worked! Thank you so much!
Bob
>--Original Message--
>See DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
>--
>Vyas, MVP (SQL Server)
>SQL Server Articles and Code Samples @.
http://vyaskn.tripod.com/[vbcol=seagreen]
>
>"Bob Albert" <bob.albert@.quest.com> wrote in message
>news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
than
>
>.
>
|||> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
Yes, Enterprise Manager is often wrong because it relies on cached data for
a lot of its values. If you want a reliable space used report, use EXEC
sp_spaceused in Query Analyzer, not Enterprise Manager. Also check into the
@.updateusage parameter. (sp_spaceused is well documented in Books Online).
Aaron
|||Narayana had the answer. I was actuallly originally
using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
the database in question and it corrected the issue.
Thanks for responding so quickly! Bob
>--Original Message--
>Yes, Enterprise Manager is often wrong because it relies
on cached data for
>a lot of its values. If you want a reliable space used
report, use EXEC
>sp_spaceused in Query Analyzer, not Enterprise Manager.
Also check into the
>@.updateusage parameter. (sp_spaceused is well
documented in Books Online).
>Aaron
>
>.
>
|||> using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
> the database in question and it corrected the issue.
Note that if you want to use the EM view, you're going to have to open QA to
execute the DBCC command every time anyway. Why not just use QA, then you
can save a script with EXEC sp_spaceused withthe @.updateusage parameter and
never wonder if your space used report is really up to date.

EMs Database Space Available Wrong

Anyone ever see a case where the Space Available number
reported in Enterprise Manager's General Database
Properties tab is wrong?
My database has the following characteristics:
-1- Has a Daily Backup Maintenance plan (no other
optimizations such as data reorg and such)
-2- Simple Recovery Model
-3- Auto Update Statistics = on
-4- Auto Create Statistics = on
-5- All other settings on Options tab = off
I went and increased the data file to 500 MB larger than
the current size and still do not see Available space
increase. It's sitting at 0.
Any explanations/assistance would be greatly
appreciated. Thanks, BobSee DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Bob Albert" <bob.albert@.quest.com> wrote in message
news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
> My database has the following characteristics:
> -1- Has a Daily Backup Maintenance plan (no other
> optimizations such as data reorg and such)
> -2- Simple Recovery Model
> -3- Auto Update Statistics = on
> -4- Auto Create Statistics = on
> -5- All other settings on Options tab = off
> I went and increased the data file to 500 MB larger than
> the current size and still do not see Available space
> increase. It's sitting at 0.
> Any explanations/assistance would be greatly
> appreciated. Thanks, Bob|||That's worked! Thank you so much!
Bob
>--Original Message--
>See DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
>--
>Vyas, MVP (SQL Server)
>SQL Server Articles and Code Samples @.
http://vyaskn.tripod.com/
>
>"Bob Albert" <bob.albert@.quest.com> wrote in message
>news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
than[vbcol=seagreen]
>
>.
>|||> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
Yes, Enterprise Manager is often wrong because it relies on cached data for
a lot of its values. If you want a reliable space used report, use EXEC
sp_spaceused in Query Analyzer, not Enterprise Manager. Also check into the
@.updateusage parameter. (sp_spaceused is well documented in Books Online).
Aaron|||Narayana had the answer. I was actuallly originally
using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
the database in question and it corrected the issue.
Thanks for responding so quickly! Bob
>--Original Message--
>Yes, Enterprise Manager is often wrong because it relies
on cached data for
>a lot of its values. If you want a reliable space used
report, use EXEC
>sp_spaceused in Query Analyzer, not Enterprise Manager.
Also check into the
>@.updateusage parameter. (sp_spaceused is well
documented in Books Online).
>Aaron
>
>.
>|||> using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
> the database in question and it corrected the issue.
Note that if you want to use the EM view, you're going to have to open QA to
execute the DBCC command every time anyway. Why not just use QA, then you
can save a script with EXEC sp_spaceused withthe @.updateusage parameter and
never wonder if your space used report is really up to date.

EMs Database Space Available Wrong

Anyone ever see a case where the Space Available number
reported in Enterprise Manager's General Database
Properties tab is wrong?
My database has the following characteristics:
-1- Has a Daily Backup Maintenance plan (no other
optimizations such as data reorg and such)
-2- Simple Recovery Model
-3- Auto Update Statistics = on
-4- Auto Create Statistics = on
-5- All other settings on Options tab = off
I went and increased the data file to 500 MB larger than
the current size and still do not see Available space
increase. It's sitting at 0.
Any explanations/assistance would be greatly
appreciated. Thanks, BobSee DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Bob Albert" <bob.albert@.quest.com> wrote in message
news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
> My database has the following characteristics:
> -1- Has a Daily Backup Maintenance plan (no other
> optimizations such as data reorg and such)
> -2- Simple Recovery Model
> -3- Auto Update Statistics = on
> -4- Auto Create Statistics = on
> -5- All other settings on Options tab = off
> I went and increased the data file to 500 MB larger than
> the current size and still do not see Available space
> increase. It's sitting at 0.
> Any explanations/assistance would be greatly
> appreciated. Thanks, Bob|||That's worked! Thank you so much!
Bob
>--Original Message--
>See DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
>--
>Vyas, MVP (SQL Server)
>SQL Server Articles and Code Samples @.
http://vyaskn.tripod.com/
>
>"Bob Albert" <bob.albert@.quest.com> wrote in message
>news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
>> Anyone ever see a case where the Space Available number
>> reported in Enterprise Manager's General Database
>> Properties tab is wrong?
>> My database has the following characteristics:
>> -1- Has a Daily Backup Maintenance plan (no other
>> optimizations such as data reorg and such)
>> -2- Simple Recovery Model
>> -3- Auto Update Statistics = on
>> -4- Auto Create Statistics = on
>> -5- All other settings on Options tab = off
>> I went and increased the data file to 500 MB larger
than
>> the current size and still do not see Available space
>> increase. It's sitting at 0.
>> Any explanations/assistance would be greatly
>> appreciated. Thanks, Bob
>
>.
>|||> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
Yes, Enterprise Manager is often wrong because it relies on cached data for
a lot of its values. If you want a reliable space used report, use EXEC
sp_spaceused in Query Analyzer, not Enterprise Manager. Also check into the
@.updateusage parameter. (sp_spaceused is well documented in Books Online).
Aaron|||Narayana had the answer. I was actuallly originally
using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
the database in question and it corrected the issue.
Thanks for responding so quickly! Bob
>--Original Message--
>> Anyone ever see a case where the Space Available number
>> reported in Enterprise Manager's General Database
>> Properties tab is wrong?
>Yes, Enterprise Manager is often wrong because it relies
on cached data for
>a lot of its values. If you want a reliable space used
report, use EXEC
>sp_spaceused in Query Analyzer, not Enterprise Manager.
Also check into the
>@.updateusage parameter. (sp_spaceused is well
documented in Books Online).
>Aaron
>
>.
>|||> using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
> the database in question and it corrected the issue.
Note that if you want to use the EM view, you're going to have to open QA to
execute the DBCC command every time anyway. Why not just use QA, then you
can save a script with EXEC sp_spaceused withthe @.updateusage parameter and
never wonder if your space used report is really up to date.