I don't have much experience in this one but if you go to management -->
SqlServer Agent and right click, one of the option you have is
Hope this helps.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
To create a multiserver environment, please check the security settings for
the SQL Server Agent service and the SQL Server service on the server that
will become target server.
It is recommended that both services be running in Microsoft Windows NT 4.0
or Windows 2000 domain accounts.(Click start->program files->administrative
tools->services. If you specified the startup account as local system
account, please change it back.)
Please refer to the SQL Server online books about the topic '' for more
In addition, I hope the following article could be of some help to you.
Eric Yang [MS]
Please do not send email directly to this alias. This is our online
account name for newsgroup participation only.
This posting is provided 'AS IS' with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security