Reschedule a job

  • My Backup job is scheduled at 8:00PM ,But I want to run it manually at 7:00PM. How can I do that? what about 8:00 PM does this also work,I don't want that.

    Also Ineed to check whether backup job was done by 8:00 PM.How do I need to check that?

  • Is it sql 2000 or 2005?  If 2000 then since you don't want the 8pm job to run disable the job for the night (remember to enable after that run time has passed). Then at 7pm right click on the job and select Start Job.  There are few ways to check if the backup job has finished.  One is to just right click on the job and see the job history.  Also right click on the database properties to verify the last backup date.

     

    If it is 2005, let me know and I will let you know the process for 2005.

  • In EM go to your Job

    Right Click- select-- Properties--Select Schedule and click delete button

    on the bottom.

    Then whenever next time you want to run manually execute that job.

       

     

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • san43 do you want to run the job manually for one night or will it be permanent? My comments were if it is just temporary.

    If it is continual then you can either disable the job or do what Sameer has said  "Right Click- select-- Properties--Select Schedule and click delete button" which deletes the set schedule then run it manually.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply