I have created a SSIS package and imported into stored package->MSDB->Maintenance Plan
I run the package by right click run package-> execute. running, no issues.
I tried to schedule this package but failed.
Job Owner: NT Authority\SYSTEM
The step created for executing the package as
Type: SQL server Intergration Services Package
Run As: SQL Agent Service Account (default)
Package Source: SQL Server (default)
Server: SGN2RYFH1S (local machine)
Use windows authentication (default)
Package: \Maintenance Plans\Server-EDrive.
Executed as user: ZONE1\Vijay. The package execution failed. The step failed.
The SQL Server , SQL Sever Agent and Intergration Services are running at my windows account (ZONE1\Vijay)
I tried the owner to sa but failed...
Anyone please help (I'm using the SQL server 2005 trial version)