4 weeks ago - last edited 3 weeks ago
Hi All,
There is a recurring bods job contains 4 stored procedures. so once the job completed sucessfully, all these 4 procedures should be executed sucessfully and this can be traced in Job Trace Log. But out of 4 Stored procedures, only 2 procedures are showing as excuted state in trace log but remaining 2 other procedures was not showing for 1 week pssibly because there was a job server shutdown during weekend. but all 4 Sr Procs are shoing in executed state in trace log after 1 week again. But the job ran with below error. Here the function call indicates the 4th St Proc which I marked as blank.
Please anyone let me know on this...
Regards,
Siba
Hi,
it looks like the procedures and/or tables got modified as seen in the error message. This might me specific names of attributes got changed or certain attributes got added/deleted from the table that the stored procedure executes against.
To analyse you would need to check the SPs and Tables.
You might also need to re-import the relevant objects into Data Services.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Julian for your comments. Yes you are 100% correct. Actually I have undo exection command for that SP in one of the script of the job in designer which was not required. So when I removed that execution command for that SP, the error didn't arise.actully that SP was not really required so earlier the exe cmd was removed after prinfn function...but there was a job server shutdown and sql server restart done so I thaught this SP was not showing in trace log bcz of that ..so I used the execution fn which was already commented(#) before..
User | Count |
---|---|
75 | |
9 | |
8 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.