question

anuk avatar image
anuk asked

Sql agent job failed with sql_severity = 16 and sql_message_id = 16389.

There is no error message in the job history. Is there any other table from where I can get the error info???? The job has sql_message_id = 16389 and sql_severity = 16. What does they mean????
sql serversql-agentsql agent
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

desperadomar avatar image desperadomar commented ·
@anuk is the job a maintenance plan?
0 Likes 0 ·

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
You can also look in the general error log. The severity is [described here][1]. You can look at the job itself by looking into the job table in the msdb database. That might help. [1]: http://msdn.microsoft.com/en-us/library/ms178567.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.