Job Executed as user: DomainName\SQLServerAgent. The step was cancelled (stopped) as the result of a stop job request.Executed as user: DomainName\SQLServerAgent. The step was cancelled (stopped) as the result of a stop job request.

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

delizat Right there with Babe Points: 749 More actions · Answer 1

Are you able to look at the job under Management Studio/sql server agent/jobs?

-Management Studio/sql server agent/jobs

-Double click the job

-select "steps" from the left window

-double click a step

Could it have more than one step and is being canceled in a step after the table update runs?

Does the user all job steps run under have permissions to everything it/they need.

Do all of the file locations/databases/tables etc.. that the job references still exist?

🙂

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

This Job has been running successfully for years on this Server when I upgraded it to SQL Server 20008 R2.

Nothing has changed.

Thanks.:-)

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/