CODEWITHSUNDEEP
sql-serverjobssql-server-agent
Biletbak.com
Biletbak.com

Reputation: 417

MS SQL Server Agent Jobs sometimes stands

Although the SQL Server Agent service jobs have started then cut and run, sometimes does not work until you restart the jobs related ever again. Why might that be?

enter image description here

Upvotes: 1

Views: 99

Answers (1)

user2001006
user2001006

Reputation: 57

Sounds like you answered the question yourself: "sometimes does not work until you restart the jobs related ever again"

so this job although it is recurring, wont continue because its dependant on other jobs? Best answer I can give with what you provided. What other jobs is this depending on? Are they recurring as well? See where this can get complicated real quick when you dont give enough info in your question?

i.e. this job(although recurring) wont continue if it needs another job to kick start it into action

Hope this helps you out.

Upvotes: 1

Related Questions