Share
ReportAttempts to run PJjob.sql (GP 2013R2) fail repeatedly. I ran the script from the Util folder in GP 2013 R2 (12.00.2038) against SQL 2014 (compatibility OK, I checked), and the following error is thrown.
Msg 14262, Level 16, State 1, Procedure sp_verify_jobstep, Line 294
The specified @database_name ('%DBNAM%') does not exist.
Parsing the query comes up clean. The job name creates, but there are no steps, so of course it will not run. I have tried several copies of this file in the event the first was damaged - no joy.
Select @@servername returns the correct server name and instance for the results obtained in Select * from master..sysservers so we can rule out a renamed server.
I have also tried to run the earlier version of the job that creates one job for each GP company. That one fails as well with an error related to companies existing in the SY01500 that are not on the SQL instance, however I have checked DYNAMICS..SY01500 with the databases known to the SQL instance and they match.
Any ideas? Thanks in advance!
*This post is locked for comments
All responses (
Answers (
