Post reply

Dynamic Subject Line

  • March 4, 2020 at 9:05 pm

    #3731075

    etvph81 wrote:

    I wasn't sure if running this package weekly if that function would update automatically every week

    GETDATE() updates every time you call it.

  • March 4, 2020 at 9:09 pm

    #3731080

    So my scheduled job is set for every monday at 7am for that location so you are saying everytime the job is executed it will update to the current week.

  • March 4, 2020 at 9:23 pm

    #3731081

    The date which appears in your subject will depend entirely on the date on which the job is run. In words: "Give me the date for Sunday of the preceding week."

    Note: as far as SQL Server is concerned, weeks begin on Mondays.

Viewing 3 posts - 16 through 18 (of 18 total)

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