SQL JOB

Question

Post reply

SQL JOB

RaviShankar1234

SSCommitted

Points: 1647
More actions
February 20, 2010 at 6:02 pm

#230197

Hi,
I have A sql job with 4 steps
step1: insert 3 values into a table
on success goto step 2
onfailure: go to step4
step2: print the inserted values
success: go to step 3
and print the output to the text file
on failure: go to step 4
step 3: delete the insertred records
on success: quit the jobs reporting success.
on failure : go to step 4
step 4: Print the error report that occured at the step1
on success : quit repoting failure
on failure : quit the job reporting failure
Print the output to the text file that we have defined in step2
can anyone explain me the scenario of getting an error to the text file. Assume that I had wantedly inserted the values into table with some errors, please explain me the scenario
Thanks,
Ravi

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

I hope that the following links are helpful to you:

http://msdn.microsoft.com/en-us/library/ms177461.aspx

For SQL Server 2000 osql -- sqlcmd utility introduced in SQL Server 2005

http://www.sqlservercentral.com/articles/Administration/failed_jobs/803/

http://www.mssqltips.com/tip.asp?tip=1865

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Paul White SSC Guru Points: 150467 More actions · Answer 2

Hi Mr. Corgi 🙂

Thanks for taking the time to track down those helpful links. As a tip, if you wrap those in IFCode [ url ] and [ /url ] tags, they will be clickable, and potentially easier for people to use 😉

Paul

(remove the spaces from those tags when you use them for real!)

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

Sorry about that. I did not realize that they were not clickable

Thanks for letting me know and for all of your contributions to this forum.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Paul White SSC Guru Points: 150467 More actions · Answer 4

Thanks!

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi