sql job

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » sql job

sql job

Rate Topic

Display Mode

Topic Options

Author

Message

mirtalaie2005

Posted Monday, October 29, 2012 4:17 AM

Forum 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

derek.colley

Posted Monday, October 29, 2012 7:10 AM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 8:19 AM
Points: 496, Visits: 584

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??! Crazy

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 »

Permissions