Re: Shipping the most current scheduled job logs
From: bjgriswold (grizgirrl_at_hotmail.com)
Date: 08/10/04
- Next message: Patty O'Dors: "Re: default constraint"
- Previous message: Brendan Reynolds: "Re: default constraint"
- In reply to: Uri Dimant: "Re: Shipping the most current scheduled job logs"
- Next in thread: Uri Dimant: "Re: Shipping the most current scheduled job logs"
- Messages sorted by: [ date ] [ thread ]
Date: 10 Aug 2004 09:11:21 -0700
The manager wants the daily logs (maint plan logs) emailed to him
every night. I need to grab only the current day's logs, not the other
89 days (retention period = 90 days). There's no need to copy, move or
backup these files.
"Uri Dimant" <urid@iscar.co.il> wrote in message news:<OqfXF2qfEHA.596@TK2MSFTNGP11.phx.gbl>...
> Hi
> > Specifically, the manager wants the day's logs (backup logs, etc., not
> > tran logs)
> Does he want a backup of the log file?
>
>
> "bjgriswold" <grizgirrl@hotmail.com> wrote in message
> news:f46e4f05.0408091639.1af71cfb@posting.google.com...
> > Forgive the newbie programmer.
> >
> > I am assisting someone else with a project to automate their
> > notifications (sans notification services, which seems like overkill).
> > Specifically, the manager wants the day's logs (backup logs, etc., not
> > tran logs) emailed to him on a nightly basis. Since SQL Mail doesn't
> > really work well in a clustered environment, I have already
> > implemented another SMTP solution which works great.
> >
> > All jobs were created using maintenance plans. The manager likes to
> > keep 90 days of logs, so I must build some logic into the job,
> > locating only the current day's logs.
> >
> > Of course the logs use ISO dates at the end (filename_200408040130).
> > Seems like this should be relatively straightforward, using getdate()
> > as a variable (perhaps comparing getdate against the ISO dates on the
> > end of the filenames).
> >
> > Any ideas are greatly appreciated.
> >
> > TIA,
> >
> > Grizgirrl
- Next message: Patty O'Dors: "Re: default constraint"
- Previous message: Brendan Reynolds: "Re: default constraint"
- In reply to: Uri Dimant: "Re: Shipping the most current scheduled job logs"
- Next in thread: Uri Dimant: "Re: Shipping the most current scheduled job logs"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|