Windows 10: I am facing issue with executing SSIS_ SQL agent jobs

Hi, I am facing one unknown issue from SQL SISS Agent Jobsusing MS DB, the problem here is it's not executing jobs and keeps on running. In logs also we can't find any entries. Here, if we create a new listener account and gave all the required permissions and then checked with the new listener account - it's running for the first time as expected and giving results as expected but after that when we re-run the same query, it's taking so long to execute no resultseven for very small queries, then entries also not capture in historyServer Win-2019

:)

 

Issue faced when PowerShell script executed through SQL Server Agent Job

I have a PowerShell script that searches for an excel file at a particular location, if found copies it as a CSV file to another location.

This CSV is used as a source in ADF - Copy Activity.

This script is not interacting with any database, nor performing any db tasks - just reading an excel and converting it to CSV at particular location.

It is working fine as intended, when executed through PowerShell ISE, but when I scheduled it as a SQL server agent job it is not doing anything. The job successfully as per the message in Job History, but it does not do anything. The message says :

=====================================================================================

Message

The job succeeded. The Job was invoked by User PMCI\VermaRachna. The last step to run was step 1 (Load_Radiotherapy_Machine_Utilization_File_Org_Src).

Message

Executed as user: PMCI\SVC_DASH_SQLDevAGT. The step did not generate any output. Process Exit Code 0. The step succeeded.

=====================================================================================

I have scheduled the Job with type as "Powershell" and the script code is pasted in Command area of the Job Step.

Since I am not getting any error message how do I know what is the issue due to which script is not doing anything when run through SQL Server agent job. Can some one help with this please. I can share the script code if required.

 

SSIS with Oracle connection doen't work in SQL job agent

I use Oracle connection in SSIS. There are two ways to access Oracle data in SSIS package, one is MSORA Connector (Microsoft Connector for Oracle by Attunity), another is ODBC connection.

I can use both ways when execute in visual studio. But it can’t be done in SQL server as step
in job agent.

Do you know what's the matter cause this issue? Thanks!

 

SSIS with Oracle connection doen't work in SQL job agent

Hi Sherry,



We see that you are facing issues with SQL server. Let me help you point in the right direction for support related to SQL server issues.



We would suggest you to post query in the
Microsoft Developer Network Forums, where we have the engineers with the expertise on server Platform and can provide solution to your query.





Regards,