When we create SQL Agent jobs on a clustered machine we always get the
physical machine name as the source (originating server). We get the same
result if we create the job in Enterprise manager and using sp_add_job.



exec msdb..sp_add_job @job_name = N'Testjob'

select * from msdb..sysjobs where name = N'Testjob'



Is this behavior by design or unexpected?

Won't this mean that the job won't work after a failover?



Thanks

Hans S

This should not effect the execution of the job.

Rand
This posting is provided "as is" with no warranties and confers no rights.