sql server agent job

  • Hi all,

    Can anybody give me an example or a link to an example of how to create SQL server agent backup jobs using SSMS?

    Thanks indeed

    Niyala

  • Hi,

    Right click the database you want to back up, select Tasks, then Back Up. Enter all the details on the General and Options tabs then click the Script button and choose Script Action to Job. Complete the job details and schedule it and you're done.

    Cath

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

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