I have a SQL job which has stopped working. Every thing was fine. One thing i noticed that there were multiple schedules with same name and different times of the day. I updated the names and give each schedule a unique name. Then i added another schedule in it just to refresh the job and it worked.
I didn't get what was the issue. My question is that does same schedule name affect the SQL job working?