You may find this article useful.

Hi Durgesh,

You can call the "DTSRUN" utility via "xp_cmdshell". Read more about DTSRUN here

Please let us know the error with which the jobs are failing. Also check the Start-up account for SQL Agent and the owner of the jobs have sufficient privileges.

The Error Log time is ;

1. The Time when SQL server was last re-started.

2. The time when the SQL Log was recycled.

Details are here

The Error Log time is ;

1. The Time when SQL server was last re-started.

2. The time when the SQL Log was recycled.

Details are here

DBCC CHECKDB reports inconsistencies if any. Details are here

Hi Desmond,

Please post the error message that you are getting when you try to start the services. You can get the information from the System Event log and the SQL...

Maintenance plans help you take backup of selected databases and automate it. Details are here. Look for "Set Up Backup Schedules (Maintenance Plan Wizard) "

2) Try changing the "Owner" of the job to the Account which has permissions on the remote share.

Hi Ashwin,

1. Just try this

2. Make sure that the SQL Server Agent start up account and the owner of the job...

This thread may help you.

Adiga (3/17/2009)

---

It depends on how to schedule the backup.

1. If a Maintenance plan is set up for it, deleting it would stop the job.

2. If a SQL Server job is...

It depends on how to schedule the backup.

1. If a Maintenance plan is set up for it, deleting it would stop the job.

2. If a SQL Server job is set...

This [/url]script might work for you.

It had also mentioned about checking the "Database growth" settings. Please check the same on the Database in question and the tempdb.