Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Agent jobs 32-bit runtime
Message
 
 
To
24/02/2022 12:55:28
General information
Forum:
Microsoft SQL Server
Category:
Troubleshooting
Miscellaneous
Thread ID:
01683666
Message ID:
01683721
Views:
32
>During a full migration from Windows Server 2008 with SQL Server 2012 on physical hardware to Windows Server 2012 with SQL Server 2012 on VM, we have discovered a weird issue.
>
>Some of the SQL Agent jobs won't even run if the 32-bit runtime is checked. Some other jobs would run only a few steps, not given much as far as troubleshooting error information. In order to make some progress, that option has been unchecked. That seems to be directly related.
>
>It is weird that this option is checked by default, but mostly weird that from one OS to another, we ended with such situation.
>
>Anything encountered the same situation during similar migrations?

Probably not directly related, but a similar question:

https://docs.microsoft.com/en-us/answers/questions/757000/ssis-data-flow-fails-with-proxy-from-sql-agent.html
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform