kusum.shah (9/11/2009)
I am a sysadmin on the server. I am able to create a SQL job. However, I am unable to modify the job. Any help would be appreciated.
You cannot alter a job in that way. script the job as a create, drop the job, make the changes to your script and then run it, recreating your job with your modifications.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]