Schedule package menu grayed out in EM

I tried to schedule a local package under Enterprise Manager\DTS\Local
package by right click local packages. However the Schedule package menu
grayed out. I used the domain login, which is SQL Server system
administrator role. This account is also in the administrators group of SQL
Server machine, and has log in as service and batch privilege. Moreover SQL
agent service is under this account.
Since SQL Server machine box itself does not install Enterprise Manager, I
add SQL Server registration from client machine, which login with above
domain account. Looks like I have all the privileges. I cannot figure out
why Schedule package menu is still grayed out. Please help. Thanks,
Charts
Hi Charts,
Thanks for your post.
From your descriptiosn, I understood Schedule Package menu is grayed out in
your SEM. If I have misunderstood your concern, please feel free to point
it out.
Based on my knowledge, please make sure SQL Agent is correctly started.
Would you please paste the SQL Server logs here? I understand the
information may be sensitive to you, my direct email address is
v-mingqc@.online.microsoft.com (make sure to remove 'online.' before you
click SEND as it's only for SPAM), you may send the file to me directly and
I will keep secure.
If you register this SQL Server in another machine, does "Schedule
Package..." menu also disabled?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Mike,
I made sure SQL agent started and running. There are so many logs in event
viewer for SQLAgent$InstanceName, most of them are not relevant. SQL Server
machine itself does not have SEM, so I used other machines to register for
SQL Server. I have two other questions. 1) Am I able to install SEM in the
server machine without affecting the SQL Server activities? 2) How do I use
dtsrun utility to schedule a package? Can you give me an example for syntax
using pseudo SQL name? Thanks a lot for your help.
Charts
"Michael Cheng [MSFT]" wrote:

> Hi Charts,
> Thanks for your post.
> From your descriptiosn, I understood Schedule Package menu is grayed out in
> your SEM. If I have misunderstood your concern, please feel free to point
> it out.
> Based on my knowledge, please make sure SQL Agent is correctly started.
> Would you please paste the SQL Server logs here? I understand the
> information may be sensitive to you, my direct email address is
> v-mingqc@.online.microsoft.com (make sure to remove 'online.' before you
> click SEND as it's only for SPAM), you may send the file to me directly and
> I will keep secure.
> If you register this SQL Server in another machine, does "Schedule
> Package..." menu also disabled?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi Charts,
Thanks for your prompt update.
For your questions[vbcol=seagreen]
Yes, SQL Server Enterprise Manager is the component of SQL Server Client
Tools, registering SQL Server instance with SEM won't affect SQL Server
activities.
Please register the SQL Server in a new machine and see whether it will
reproduce this issue on that new machine.
[vbcol=seagreen]
an[vbcol=seagreen]
Here is a simple example: C:\> dtsrun /s <server name> /e /N <DTS package
name>
If you want to schedule it, create a job and let it execute the command in
a regular time.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thanks Mike,
It’s very helpful. For question 1) it’s not the issue registering SQL
Server instance. I don’t have SQL enterprise manager installed in the server
machine, and I wanted to install this tool without affecting server. I guess
I need to put SQL Server 2000 installation CD in and start install process.
Can you give me some instruction for safe installation since this is existing
server?
Charts
"Michael Cheng [MSFT]" wrote:

> Hi Charts,
> Thanks for your prompt update.
> For your questions
> Yes, SQL Server Enterprise Manager is the component of SQL Server Client
> Tools, registering SQL Server instance with SEM won't affect SQL Server
> activities.
> Please register the SQL Server in a new machine and see whether it will
> reproduce this issue on that new machine.
> an
> Here is a simple example: C:\> dtsrun /s <server name> /e /N <DTS package
> name>
> If you want to schedule it, create a job and let it execute the command in
> a regular time.
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/tec...rview/40010469
> Others: https://partner.microsoft.com/US/tec...pportoverview/
> If you are outside the United States, please visit our International
> Support page: http://support.microsoft.com/common/international.aspx
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi Charts,
Thanks for your update.
Based on my knowledge, if you install SQL Server in the machine, SQL Server
Client Tools will also be installed, so I am not very sure your scenario.
Would you please help me explain it clearly? More detailed descriptions, I
believe, will make us closer to the resolution.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Never mind Mike,
I found EM component in the server component installation. Thanks for your
help.
Charts
"Michael Cheng [MSFT]" wrote:

> Hi Charts,
> Thanks for your update.
> Based on my knowledge, if you install SQL Server in the machine, SQL Server
> Client Tools will also be installed, so I am not very sure your scenario.
> Would you please help me explain it clearly? More detailed descriptions, I
> believe, will make us closer to the resolution.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi Charts,
That's OK and let's go back to see why Schedule package menu grayed out.
If you register this SQL Server in another machine, does "Schedule
Package..." menu also disabled?
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.