Best gaming deals on Amazon | This weeks Xbox deals with gold

Help with planification of job

Category: sql server tools

Question

Ecxtazy on Mon, 12 Jun 2017 06:19:33


Hey everyone,

After 48 hours of research, and in a desesperate move, i decide to write at the last forum on my problem.

I have a big deal, when i create a job and i'm configuring it to be launch with the planification, it won't run. There is no error in the logs, and in the job planification history, it say he isn't launch, haven't been execute. This is quite obvious. I don't know why my planification don't work. Since i've already been able to run it in the past. 

Thank you in advance !

Replies

Davy_Wang on Mon, 12 Jun 2017 10:22:00


Hi Ecxtazy,

Could you please tell me the meaning of the ‘planification’? Does that mean SQL Server job schedule? If so, first please verify the configuration of your job propertity. You could right-click Job Schedule Properties in the Schedules of Job Properties to see if it is enabled:

In addition, please verify if the job is running on a different account that has unavailable rights to execute the job and you could refer to this thread. Also make sure if the permission of the service account has been changed.

For more information, please refer to this thread.

Hope it can be helpful
Regards,
Davy

Olaf Helper on Mon, 12 Jun 2017 10:50:50


And is "SQL Server-Agent" Service running; that one schedules & runs the Jobs?

Latest posts in the category


sql server dbengine

language understanding intelligent service (luis)