1,034 reputation
2526
bio website
location Sydney, Australia
age
visits member for 1 year, 8 months
seen Apr 7 at 6:09

Feb
6
asked Server default collation change or not change
Jan
28
awarded  Popular Question
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