I've seen several posts pertaining to this topic, but none of them covers what I'm having an issue with.
I'm trying to create a "master job server". Essentially, I want to control all maintenance jobs from one central location. I've created SSIS packages that handle full backups, transaction log backups, index rebuilding, etc. on all of my production boxes.
I've stored those packages in SQL Server.
What I'd like to do now is create a separate job for each of those tasks on one central SQL Server and run those packages from there. I've been successful in creating a test job. The only step in the job is an SSIS PAckage execution step.
The step successfully found the package I want to execute on the target server.
When the job ran, I got the follwoing error:
The job failed. Unable to determine if the owner (ADMINSYS\arobinsf) of job SFO2PQE03 - Database Backup (FULL) has server access (reason: Could not obtain information about Windows NT group/user 'ADMINSYS\arobinsf', error code 0x2751. [SQLSTATE
42000] (Error 15404)).
I want to make sure this job is executing on the remote server and not trying to execute locally. Is there something I'm missing in the set up of this job?
I should also mention that the SSIS packages were created in SQL2K5, but I'm executing them from SSMS for SQL2K8.
Any help would be appreciated!
A. M. Robinson
View Complete Post