sql job

• mirtalaie2005

  Newbie

  Points: 1

  More actions

  October 29, 2012 at 4:17 am

  #393483

  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

• derek.colley

  SSCrazy Eights

  Points: 8040

  More actions

  October 29, 2012 at 7:10 am

  #1553713

  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 https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
  My blog: http://uksqldba.blogspot.com
  Visit http://www.DerekColley.co.uk to find out more about me.