검색 결과: "#sqlserveragent"

11 개 결과
Lloyd Doug Jessee
Lloyd Doug Jessee@cf_ldj·
Ok, hopefully someone has a solution. On #sqlserver2019 have two databases, I want to select data from one, write it to the other, in a scheduled job (#SQLSERVERAgent) so it happens everyday. It is a stored procedure that works great if I run it by hand, but run it from a scheduled job, it fails every time. SQLSTATE 08004 Error 916 (the database selected from) “is not accessible under the current security context” If I limit it to one database, works fine. Any work around?
Indianapolis, IN 🇺🇸 English
0
1
0
30
Pythian
Pythian@Pythian·
😕 #SQLServerAgent service on #Linux not starting? Reza Azizi's comprehensive 10-step guide tackles hostname-related issues, system logs, & more to get you back on track. Learn to diagnose roadblocks & resolve those headaches today: hubs.ly/Q01SLld90 #LoveYourData
English
0
0
1
122