Starting Jobs in Powershell using Job Name

  When starting jobs in powershell with smo, you have to use the jobname and categoryID. If you have same job name on multiple servers that could be in different category, and if you are running a single script that connects to multiple servers and starts job, it will not work because JobName+CategoryID combination might…

3

Troubleshooting: SQL Agent can’t start without SQLAGENT.OUT telling the reason

SQLAGENT.OUT, the log file for SQL Agent, is usually the first place to investigate what could go wrong.  However, when SQL Agent cannot start,  a new SQLAGENT.OUT even is not generated at all.   What should we investigate?  If this kind of things happens, a possible reason is due to the file permission on SQLAGENT.OUT that…