I would like to develop an agent that could run on any databases, this agent would get all information related to scheduled agents :
-
schedule (daily, weekly…)
-
on which day it should run and at what time
-
what are the restrictions
-
etc.
Note: I don’t have admin rights, I know that is possible to get all agents that are scheduled to run on a specific server, that’s not what I’m expecting, all I want is which agents are scheduled on a specific database and all properties related to each of these agents.
Any suggestions would be appreciated.