Results 1 to 8 of 8
  1. #1
    Join Date
    Nov 2003
    Location
    Colombo ,Sri Lanka
    Posts
    7

    Exclamation Unanswered: Edit/Delete Schedeule Job

    Can we edit/Delete schdule Job

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245

    Re: Edit/Delete Schedeule Job

    There's not a lot of background to this question, but the basic answer is "yes".

    Perhaps if you could post a bit more detail?

    hmscott

    Originally posted by dinesh123
    Can we edit/Delete schdule Job

  3. #3
    Join Date
    Nov 2003
    Location
    Colombo ,Sri Lanka
    Posts
    7
    This is the way I did

    I created a Job set at some schdule

    SOmetimes later I want to change the Job schdule (Say Daily to Weekly)

    How can I do this

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You could start by reading Books Online. This is simply a matter of clicking buttons in Enterprise Manager.

    blindman

  5. #5
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    or you can use

    sp_delete_jobschedule
    and
    sp_add_jobschedule

    if you want to do it via T-Sql
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    If you are trying to do this dynamically then use:

    sp_update_jobschedule

    Otherwise, like blindman mentioned, you can modify it manually.

  7. #7
    Join Date
    Nov 2003
    Location
    Colombo ,Sri Lanka
    Posts
    7
    Sorry!!1
    I was unble to find the jobs in the enterprise manager


    Thankx u all

  8. #8
    Join Date
    Feb 2002
    Posts
    2,232
    Enterprise Manager -> Server Name -> Management -> Sql Server Agent -> Jobs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •