meta user
network profile
| bio | website | |
|---|---|---|
| location | Sydney, Australia | |
| age | ||
| visits | member for | 9 months |
| seen | 2 days ago | |
| stats | profile views | 43 |
|
Jan 25 |
comment |
SQL Server Database Synchronization Well said Darin! That's it :) |
|
Jan 23 |
revised |
SQL Server Database Synchronization added 1 characters in body |
|
Jan 23 |
answered | SQL Server Database Synchronization |
|
Jan 20 |
comment |
sql agent job hangs without any errors or warnings Sorry, I was typing the comments above from my mobile and made mistakes, which the forum did not let me to delete or edit them after 5 minutes. Do you have call of xp_cmdshell in your job? Is it possible that you are trying to use a resource that is not available at time of running Or the user you have set up to run the job (scheduled) does not have the required rights to access the resource? Also what is the wait type in your ssis package? Is it PREEMPTIVE_OS_PIPEOPS? If so, please check the link below: sqlservercentral.com/Forums/Topic802987-110-1.aspx#bm1339542 The links below al |
|
Jan 20 |
comment |
sql agent job hangs without any errors or warnings Do you call of xp_cmdshell in your job? What is the wait type in your ssis package? The links below might be helpful: |
|
Jan 18 |
accepted | How to identify the db orphan mdf and ldf files |
|
Jan 17 |
awarded | Popular Question |
|
Jan 17 |
asked | How to identify the db orphan mdf and ldf files |
|
Jan 4 |
answered | How can I capture queries that fail on the SQL Server due to connection failures? |
|
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) |
