June 5, 2013 at 8:08 am
Hi
We use a CMS to run our jobs on all the servers. I have logged onto ssms on the cms server and created a job under the Multi-Server-Jobs folder.
The cms server only has the system databases and a redgate database for our sql monitor, so the problem (if it is a problem) is that i cant seem to select the databases i want the server to run the job against (the job is in the form of Stored proc).
In the Job step properties under the General tab, i have the step name, type (Transace-SQL script), Run as (this is blank) and the database (this currently shows MASTER). Then in command box i have EXEC dbo.StoredProcName.
Under the 'TARGETS' tab i have selected all the servers i want the job to run against.
So in summary I am concerned that I will be running this Sp against the MASTER db (which is selected in the database section of the properties of the job on the CMS)when i need to be running it against the database X on the other servers
June 6, 2013 at 2:06 am
hi!
Please check the LOGIN you are using if it has access to the databases. 😛
Could be the account your using has limited rights to the databases.
Regards,
JM
===============================================================
"lets do amazing" our company motto..
June 6, 2013 at 2:49 am
Hi
The login has full sys admin rights - its the main account we use to create jobs.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply