I created new database from a backup of another database.I have one task scheduler which is connected to the main database. after coping the database the task scheduler is not working with main database but working with copy database.Can anyone tell me what could be the reason? I check permission, role everything looks good to me. And it was working perfectly before.
What I have tried:
I checked all the roles and permissions everything is same as my copy database. I tried all possible ways did not get success. I really don't understand what is wrong after copying it. The code was running absolutely fine. before making copy. I did not change anything in the application or the database.