Comments posted to this topic are about the item Stairway to SQL Server Agent - Step 2: Job Steps and Subsystems
It would be nice if sysjobs and other table are mentioned as scripts to accent the name,steps etc.
Earlier today, I was struggling to diagnose a T-SQL job that selects info from a master db table and sends them to an email. I kept getting SELECT permission issues in the error message. I didn't realize that jobs don't always run as the job owner and it was running instead under the SQLServerAgent account, that wasn't setup as a login on SSMS. As soon as I added the SQLServerAgent account it started working just fine.
This was the only job that was all T-SQL rather than PS or CMDExec, so none of my other jobs were failing.
Viewing 3 posts - 1 through 2 (of 2 total)