1. Is sql server agent is started?

2. go to Enterprise Manager--> Jobs

1) Is the job enabled?

2) Is the job schedule enabled? 

3) Do you see the date&time (your schedule) for "Next...

MS has a KB may give you some details.

How to configure SQL Server to use more than 2 GB of physical memory

http://support.microsoft.com/kb/274750

Your optimization may have reindex option which will consume a lot of T-log space. 

see Table 5 here: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Monitor Database Growth on Multiple SQL Servers

http://www.databasejournal.com/features/mssql/article.php/3339681

You can take the T-SQL part only.  No need to use VBscript.

The core code is:

exec master.dbo.xp_fixeddrives -- for disk space

exec master.dbo.sp_msforeachdb

"select @@servername...

BCP has -F option to skip row(s).  -F2 to start from 2nd row so you do not need delete the first row (column header) each time.

bulk insert has firstrow option to...

There is a column modify_date in sys.objects table which means:

Date the object was last modified by using an ALTER statement. If the object is a table or a...

SQL Server 2005 Webcasts:

http://msdn2.microsoft.com/en-us/sql/aa336323.aspx

sqlskills.com is a good site and kimberly is an excellent speaker.  -- This is not an ad.

http://www.sqlskills.com/blogs/kimberly/

Welcome on board.  Just a couple links for now. 

0. What's a DBA? - An Overview

http://www.sqlservercentral.com/columnists/sjones/whatsadbaanoverview.asp

1. SQL Server administration best practices - This link highlights the...

Thank you Mahammed.  The script you provide can give me some helpful hints.

"Last Run Status(Start Date), Next Run Date columns" are needed as I need to monitor the job execution...

In dos cmd line, try to make the bat file work first then copy the bcp command line code to the bat file.

cmd> bcp mytable in E:\SprintBills\Copyof2006Dec08.txt ......

You may need...

You can use BCP (for both SQL2000 and SQL2005). check books online "BCP Utility".

You can create a job to automate this process

job step1: T-SQL: create table mytable (if needed)

job step2:...

A log file can only be shrunk to a virtual log file boundary.  Take a look books online "Shrinking the Transaction Log".  Hope this helps.

Take a look here...

http://support.microsoft.com/kb/268591

Thank you Bill and Morten for your suggestion.

I am wondering whether this approach is good for sa password as the password is plain text...

sp_changedbowner 'sa'