I have inherited a database and jobs that go with it. One of the jobs has a step that executes a proc but does not specify which database to find the proc in. There are actually 2 different databases on this server that have procedures with the name listed in the job step. The job runds successfully. Does it execute this proc in every db that has a proc by that name? If not then which db does it execute against?
See attached screenshot of the job step.