Reputation
1,339
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
5 29 51
Impact
~363k people reached

  • 0 posts edited
  • 0 helpful flags
  • 131 votes cast
Jan
2
comment Transaction and Try-catch in SQL Server Job
Thanks for your helpful answer and fantastic website! However I'm wondering if still I can use this pattern with a simple DML statement (not a stored proc)? Also do we have to save the transaction as below? (I don't have a store proc to use): save transaction usp_my_procedure_name;
Jan
2
accepted Transaction and Try-catch in SQL Server Job
Jan
2
comment Transaction and Try-catch in SQL Server Job
Thanks for your reply, could you please give me a hint how to write it to a log?
Jan
2
asked Transaction and Try-catch in SQL Server Job
Dec
31
revised SQL Server Job logging best practice
edited tags
Dec
31
asked SQL Server Job logging best practice
Dec
30
accepted Calling a SQL Server job within another job
Dec
28
comment Calling a SQL Server job within another job
Thanks for your reply. It seems we have to go for Option 2. I'm not quite sure whether I understood it correctly though. Do you mean I should create the scripts for both jobs, and then append steps of job2 to end of job1? Is that right?
Dec
28
asked Calling a SQL Server job within another job
Dec
27
comment Restore a Database to a New database (T-SQL)
I added 'RECOVERY', but still get the same error.
Dec
27
asked Restore a Database to a New database (T-SQL)
Dec
10
comment Login failure when running a SSIS package from a SQL Server job
Yes, it is done in ODBC connection, and the test connection can be established successfully there, but I know know how force SQL Server job use that credential, e.g: userId = dba not the SQL server Agent user.
Dec
10
revised Login failure when running a SSIS package from a SQL Server job
added 303 characters in body
Dec
10
answered how often to run Tablediff
Dec
10
asked Login failure when running a SSIS package from a SQL Server job
Dec
10
accepted error in Execute SQL Task with parameter
Dec
5
comment error in Execute SQL Task with parameter
It is OLE DB connection, referring to a local database.
Dec
5
asked error in Execute SQL Task with parameter
Nov
23
revised Microsoft Visual Studio is Busy
edited tags
Nov
22
asked Microsoft Visual Studio is Busy