how to put the sql-logfiles online?

[vineetbindal]

HI all,

I have been given a new task to do. its very interusting but i have no idea how to do that. We have several Databases and everynight at 2:00 am there are, certain jobs (such as taking backup ,cleaning up data tables) run on all the databases. Everyday some person has to login and check if the jobs are done or there was some error, what we want is, we want to develop some machenisam that whenever there is a faluire in the job we want to get an e-mail. Other thing is there is a log mentained by sql-server 2005 for all these jobs like how much time taken date etc. we want to put all these things online. can some1 please give me some idea about how to do that.

Regards,

Vineet Bindal

[ck9663]

It all depends on what kind of job you are running. Is it all done via T-SQL and was added as a scheduled job? What kind of log? Is it a table being updated by your process or the default SQL Server log?

-- CK

[vineetbindal]

HI CK,

These are all Scheduled jobs. and we running them through sql server agent.
These jobs includes re-building indexes, Cleaning up some data from some tables, Backing up database.


Another thing i wanna know is. we are taking backup everyday which creates a random backup file name, how can we restore the database automatically, we have to do it manually becouse we dont know what will be the file name. all the file names are quite similer except some version and timestamp.(the creater gives them version and timestamt when created so we know which one is latest)
regards,
Vineet

[ck9663]

You can change your code to handle the notification. SQL Server can send email as notification. You can also setup the job schedule to send an email if it fails.About the file, you can grab the files on the folder and sort it by date/time.

-- CK