Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

mekohler

Technical User
May 4, 2007
64
CA
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
 
 http://files.engineering.com/getfile.aspx?folder=7047ce56-78d9-4416-a06a-3d630e7fcb42&file=SQL_Log_File.jpg
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top