• Lowell (10/22/2012)


    matt.gyton (10/22/2012)


    Hi Lowell,

    These are just standard SQL Agent Jobs being run on a schedule, so I'm assuming I could just change the default language setting for the login they are being run under (currently the SQL Agent Service account)?

    Would changing the default language for 'NT SERVICE\SQLSERVERAGENT' do this?

    Thanks

    i think so yes, but you'd have to test it. it would be better to change whatever script you are using to not be sensuitive to datefirst instead;

    can you explain what is not running or occuring correctly because of that setting?

    Basically each Job runs a windows CmdExec command, which kicks off a Netbackup procedure. There are 4 jobs, Weekly1, Weekly2, Weekly3 and Monthly. Each weekend, one of these jobs must be run consecutively on the Friday, Saturday and Sunday as follows:

    Week 1: Weekly1 runs Friday, Saturday and Sunday.

    Week 2: Weekly2 runs Friday, Saturday and Sunday.

    Week 3: Weekly3 runs Friday, Saturday and Sunday.

    Week 4: Monthly runs Friday, Saturday and Sunday.

    The problem is that because SQL considers Sunday the first day of the week, the Friday and Saturday are considered to be part of one week, but the Sunday is part of the next week, so instead of running on consecutive days they run as follows:

    Week 1: Weekly1 runs Sunday......Friday, Saturday.

    Week 2: Weekly2 runs Sunday......Friday, Saturday.

    Week 3: Weekly3 runs Sunday......Friday, Saturday.

    Week 4: Monthly runs Sunday......Friday, Saturday.

    Hope that makes sense!!