| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-06-26 : 15:57:49
|
| How to find the Maintenance plan owner from query editor?I am using the folloiwng query, select owner,* from msdb.dbo.sysmaintplan_plans But this returns the owner of the Job! ------------------------I think, therefore I am - Rene Descartes |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-26 : 16:03:44
|
| Maintenance plan creates the job by default. That will be owner of Maint plan as well. |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-06-26 : 16:09:29
|
| consider this, 1. MP was created by owner SA2. so the job will be owned ny SA3. For some reason we changed all the job owner to domain accounts4. some one changed the SA password 5. MP failed. 5. I neeed to find out the MPs owned by SA------------------------I think, therefore I am - Rene Descartes |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-26 : 16:16:28
|
| If job related to MP succeed ,then why you care about MP? If job related to MP failed, then its because of security issue. How come somebody changed SA Password? |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-06-26 : 16:24:02
|
| 1. Job failed. >> How come somebody changed SA Password?2. There are multiple admins. I don't know why it was done, it was some time back.------------------------I think, therefore I am - Rene Descartes |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-26 : 16:54:34
|
| What error exactly you get for failed job? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-28 : 00:35:55
|
| There is connection propertity in MP, check setting in it. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-06-30 : 09:13:12
|
quote:
Originally posted by rmiao
There is connection propertity in MP, check setting in it.
I know that. My question is where these connection details are stored?------------------------I think, therefore I am - Rene Descartes |
|
|
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-06-30 : 11:17:00
|
| msdb.dbo.sp_help_job will give you trhe owner of the jobs and other info about jobs.[The Edited information was for the other Post..]Maninder |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-30 : 23:18:53
|
| >> where these connection details are stored?Take look at msdb.dbo.sysdbmaintplans, there is column named owner. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-07-01 : 09:20:54
|
quote:
Originally posted by rmiaoTake look at msdb.dbo.sysdbmaintplans, there is column named owner.
That is the JOB owner NOT maintenance plan owner!------------------------I think, therefore I am - Rene Descartes |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-04 : 20:59:23
|
| Then need to check plan's connection setting. |
|
|
|
|
Maintenance plan owner