14,494 questions
May be it is permission issue.
Login to the SQL Server using SQL Agent account and see if you run the package manually.
SQL Server Agent Failed to execute job
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 16%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECL%3C/text%3E%3C/svg%3E)
CHENG LUN WU
1
Reputation point
Every SQL Server experts~I have a problem
I want to use SQL Server Agent to excute job&schedule in SSMS,But appeared a mistake:
Executed as user: NT Service\SQLSERVERAGENT. The process could not be created for step 1 of job 0xF6FCB18EFC96C348BB90BE7CED29B30D (reason: The system cannot find the file specified). The step failed.
My job is to read the package on my file,and my SQL Server is connect to vpn and then connect to SQL ,not use Local SQL.
Similar problems on the Internet can't solve it. have any suggestions or way?~thanks!
SQL Server Other
{count} votes
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2021-06-05T08:59:33.92+00:00 I think you need to give us more details. What type of job step is this? Can you show us the definition of the job step?
I don't understand what VPN has to do with this. Agent runs on the same machine as SQL Server. Or is the file which the job is trying to access on a remote machine with a VPN connection?
-
CHENG LUN WU 1 Reputation point
2021-06-05T11:16:53.157+00:00 The Type I use SQL SERVER Integration Service Package,and Executive identity is SQL Server Agent Service
Acountand my package is on local,so path like this:
C:\Users\Infofab-S508\source\repos\Integration Services Project1\Integration Services
Project1\SAPERP_EXTRACTION_SQLSTG_20210604.dtsx.If I set job&schedule in my local SQL SERVER Agent can success,but use there SQL Server Agent is failed.
.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 23%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
Jeffrey Williams 1,896 Reputation points2021-06-07T19:16:30.283+00:00 You appear to be trying to execute the project/package from within the VS path. That is not the appropriate way to deploy SSIS packages. You need to deploy the package to an Integration Services Catalog - preferably one that has been set up on your remote SQL instance.
Once it has been deployed you can then schedule it using SQL Server Agent on the remote system.
Sign in to comment
2 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 35%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHU%3C/text%3E%3C/svg%3E)
Hafeez Uddin 296 Reputation points2021-06-05T18:42:38.49+00:00 -
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
2021-06-05T20:26:45.563+00:00 and my package is on local,so path like this:
C:\Users\Infofab-S508\source\repos\Integration Services Project1\Integration Services
Project1\SAPERP_EXTRACTION_SQLSTG_20210604.dtsx.By "local", you mean your local machine?
That is not going to work out. C:\ for SQL Server Agent is C:\ on the SQL Server machine. Agent has no knowledge about your local disk.
You need to copy your package to the SQL Server machine.
-
CHENG LUN WU 1 Reputation point
2021-06-06T02:59:24.457+00:00 Thanks for reply,local is mean my machine,so package is on my C disk.
So If I connect to other people SQL Server in SSMS,then SQL Server Agent can't read my package and set up
job? -
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
2021-06-06T09:47:29.817+00:00 Correct. SQL Server, including Agent, lives on its own machine, with its own C: drive.
-
CHENG LUN WU 1 Reputation point
2021-06-06T11:23:21.19+00:00 OK~thanks ,I research it for many days
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff2021-06-07T06:09:08.913+00:00 Hi @CHENG LUN WU ,
Did your issue has resolved? If the reply from Erland has resolved your issue, please make the reply from Erland. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
And if you have further question, please feel free to ask.
Sign in to comment -