Home Forums SQL Server 2016 SQL Server 2016 - Administration My Backup Jobs Aren't Working - Permission Issue? RE: My Backup Jobs Aren't Working - Permission Issue?

  • March 8, 2018 at 5:53 am

    #1982380

    Seggerman-675349 - Thursday, March 8, 2018 5:37 AM

    log on to the server using an account Machine Name \Administrator
    open Management Studio
    go to Job Agents at the bottom
    Add New Job
    add Step with T-SQL to do backup (which if pasted into Query Window works)
    Add Schedule
    I added an alert to notify my client when it completes (I had to add his email elsewhere)

    What message is shown of the job step in the job history?  (expand the job in Job History to get the jobstep output)
    You can additionally add some PRINT statements to the T-SQL code in the jobstep. That way you can extra check if the code has run, becuase this print output will also be visible in the job history.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **