Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
visitphanikumar
Starting Member
1 Post |
 Posted - 2008-02-04 : 05:38:13
|
| I have created a sql job which executes some set of stored procedures. These stored procedures have been written in a generalized way so that, they populate the results but with some errors.(These errors are not consistent). When ever I execute these sps in query analyzer, results are being displayed but with some errors. But when I incorporate these in sql job steps, the job is getting failed and is getting rollbacked. I want this transaction to get committed or to remove the error handling so that, the job executes and populate results inspite of some errors....it will be sme syntax error or logical errorit is not consistent...like each time of its execution we may get sme errors which may nt cme 4 nxt time... Plz help me outthanks in advance |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-04 : 23:14:03
|
| What's the error you got? |
 |
|
|
|
|
|
Sql-jobs