locked
Moss 2007 Timerjobs and SQL Agent jobs RRS feed

  • Question

  • I would like to know, how many SQL agent jobs does MOSS 2007 creates? Is there a relationship between SharePoint timerjobs and SQL agent jobs? I can't tell if every timerjob or any timer job creates a SQL agent job? So in other words is there a list that shows all SQL Agent jobs associated with SharePoint?

    Thanks in advance
    MA
    Thursday, December 4, 2008 8:46 PM

Answers

  • I have never seen a list, but yes there is a relationship between timer jobs and agent jobs.  An agent job's name will always have part of the SSP name in it - so you could always use some type of agent job tracker in SQL to monitor and see what the associations are.
    Dan Lewis
    MCAD, MCTS
    http://weblogs.asp.net/danlewis
    Sunday, December 7, 2008 5:46 PM