July 5, 2012 at 3:57 am
Hi,
I have two packages & four stored procedures.
I am calling all these through a SQL server job. It may be possible that there is a change in requirement & I have to call all these through a master package.
I am trying to call them through a Job in following way:
1.Importpackage
2.Stored Procedure 1
3.Stored Procedure 2
4.Stored Procedure 3
5.Stored Procedure 4
6.Export Package
Now I want that if there is an error in any of these items during execution ,the error must be written to a Windows Application Event Log for an item causing an error.
Is it possible ?
Windows Application Event Log shows log when package execution is successfull.
Please guide me for this...........!!!!
Thanks ....
July 5, 2012 at 4:51 am
tush002sunny (7/5/2012)
Hi,I have two packages & four stored procedures.
I am calling all these through a SQL server job. It may be possible that there is a change in requirement & I have to call all these through a master package.
I am trying to call them through a Job in following way:
1.Importpackage
2.Stored Procedure 1
3.Stored Procedure 2
4.Stored Procedure 3
5.Stored Procedure 4
6.Export Package
Now I want that if there is an error in any of these items during execution ,the error must be written to a Windows Application Event Log for an item causing an error.
Is it possible ?
Windows Application Event Log shows log when package execution is successfull.
Please guide me for this...........!!!!
Thanks ....
Don't know If I got you or not. There is an option for 'Write to Windows application event log' in notification tab of properties windows of SQL Jobs.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply