May 26, 2015 at 5:13 am
Hi,
I'm having trouble running a job. I get a very general error message:
"Execution of job 'Backup System Databases.Subplan_1' failed. See the history log for details."
Logs are un-revealing. The package runs no problem when I run in from inside Visual Studio I have noticed
* I checked permissions on the folder and its the same as other packages that are working...
* I stripped the package down to very little and it works in VS but not from when I run it inside SSMS
* Job name is present inside the msdb.sysjobs table
I'm running out of ideas 🙁
Can anyone please help me? Any suggestions/ideas/comments/user experience you would like to share?
Thanks,
j.
May 26, 2015 at 8:29 am
What does the execution log tell you? It'll give both the taskthat the error occured on, and the error that was returned.
To view the log, expand the Integration Services Catalogs folder in SSMS, then navigate the folders to your project and package. Right click the package and select Reports -> All Executions.
Click the All Messages hyperlink, next to the execution that failed, and it'll open another report. There will be a table near the top of the report with Error messages, and where they happened.
If that doesn't make the error more apparent, post back with the error message and what the task that failed is doing.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 26, 2015 at 9:42 am
Apologies Larnu - I spotted the problem before I saw ur post. For some reason the job associated with the maintenance plan had become replicated and renamed slightly.
Don't ask me how this happened. I removed the replicant and the maintenance plan runs nicely. So does the job.
I'm a bit new to SSIS/Maintenance plans & jobs and I suspect it was something that I did.
Apologies,
J.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply