• crazy4sql (2/14/2011)


    ii) i have a job which is running under a disabled windows account and still the job runs fine. How is this possible? The job owner is a disabled account, how is the job running?

    could be the possibility that same job is created in some other server as remote job with some other account.

    You can query in msdb sysjobs to get the name of the job and then using where condition you can find out which other server have the same job. If you have many database server then you can use cursor to run through all your listed server and get the required information.

    Thanks. Not sure what are you trying to get by saying "could be the possibility that same job is created in some other server as remote job with some other account."...if even there are jobs with same name and account on other server..so what?