Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql job Expand / Collapse
Author
Message
Posted Monday, October 29, 2012 4:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 29, 2012 5:13 AM
Points: 1, Visits: 10
Hello

I have sql servers in 7 Office & I neet to check sql agent (Job) from center Office , i have vpn port between all office & center office , i install the (Idera SQL Job Manager) on my server and all vpn port are active but when i register any server to this software i see the database but don' see sql job in sql agent of offices .

anybody can help me ?

thanks alot
Post #1378181
Posted Monday, October 29, 2012 7:10 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, August 22, 2013 9:13 AM
Points: 496, Visits: 601
Check that the user configured in Idera has the correct permissions to view SQL Server Agent jobs, best achieved by assigning that user to a fixed DB role as per the MSDB database fixed roles for SQL Agent (see URL: http://msdn.microsoft.com/en-us/library/ms188283.aspx )

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!

Want to get the best help? Click here http://www.sqlservercentral.com/articles/Best+Practices/61537/ (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.
Post #1378235
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse