Post reply

Subject line in e-mail report subscriptions

  • February 28, 2007 at 5:19 pm

    #172280

    I've setup some scheduled deliveries of PDFs to mailboxes. Currently the subject lines for these e-mails use @ExecutionTime, which puts a long, ugly date-time.

    Two things:

    1. What other parameters are available here? Are they simply the global parameters shown here:

    http://msdn2.microsoft.com/en-us/library/ms157274.aspx

    2. What control do I have over these parameters? Can I create a function in Visual Studio to give me the date in "070301" format (i.e. yymmdd)?

  • March 2, 2007 at 6:18 am

    #692818

    If you are using a data driven subscription you can set a subject field to anything you want.

  • March 5, 2007 at 2:33 pm

    #693214

    That's a shame - I don't have SQL Ent. Ed.

    Isn't there any other way I can do it?

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

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