Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training

Installation and Technical Issues

Reply
Topic Options
Regular Contributor
skipwhitten
Posts: 257
Registered: 11-03-2008
0
Accepted Solution

SQL Server Agent/Maintenance Plan not displaying in SQL Server Management Studio

Options

01-30-2012 07:09 AM

I am using MAS 500 v7.05.20.0 with SQL 2000. When I use MS SQL Server Management Studio (v9.00.2047.00) to see if a maintenance plan was ever created, the SQL Server Agent is not displayed in the menu so I can't see if the jobs were ever created or if they were and are not running. The MS SQL Server Management Studio is NOT installed on the SQL Server. Could this be the reason I'm not seeing the Agent menu item?

Thanks in advance.

 

Skip

Skip Whitten, MCP
Systems Administrator
Biocompatibles, Inc
Message 1 of 3 (88 Views)
 
Reply
trodman
Sage MAS 500 Customer
trodman
Posts: 235
Registered: 02-13-2009
0

Re: SQL Server Agent/Maintenance Plan not displaying in SQL Server Management Studio

Options

01-30-2012 10:47 AM

Not positive about this, but I think you have to be logged in as an Administrator to see it.  Are you?

Tim Rodman
Programmer Analyst
rodmant@robbinstbm.com
Version 7.30.6.0 (March 2011)
Message 2 of 3 (77 Views)
 
Reply
Regular Contributor
skipwhitten
Posts: 257
Registered: 11-03-2008
0

Re: SQL Server Agent/Maintenance Plan not displaying in SQL Server Management Studio

Options

01-30-2012 11:15 AM

Yes I am but I did find the answer I needed. SQL maintenance jobs are running weekly to test integrity and rebuilding the indexes. Thanks for your help.

 

Skip

Skip Whitten, MCP
Systems Administrator
Biocompatibles, Inc
Message 3 of 3 (74 Views)
 
Reply