SQLServerAgent Error: Request to run job "jobname" (from User xxxx\aaaa) refused because t

[mekohler]

Hi, I've attached a screen shot of the error log from a SQL Server. I have a job that runs fine from Business Management Studio and from within SQL, but when I run it through the job agent I get an error. Looking at this log, is the error a critical error? Does the job still complete what it is meant to. I'm importing data from a proprietary database dealing with a tax database so it's hard to tell if the data in SQL has been updated, there not have been any changes in the source database.
Thanks,
Michael Kohler

 

[Motlatjo]

Hi Michael

To my understanding, your job fails when it tries to send a message.
First ensure that your Messenger configurations is correct and well tested.

Use the below query to test it on Management Studio:
EXEC msdb.dbo.sp_send_dbmail
@profile_name='Your Prifile Name',
@recipients='CellNumber',
@subject='Subject',
@body = 'Server Job: Load Succesfull'

You can also Configure your SMTP Server for emails.

I suggest that you modify your package to have logging tasks (Execute SQL Task), the first one will just
send a string to a table that says "The load/Update has started", then follows your main Data Flow Task to do the job,
then you add the second logging task to send a string in the same table to say "The load/Update has completed".
This will help you to answer the questions you have.

Regards