March 22, 2010 at 11:07 am
Hi
I have created couple of SSIS packages, and scheduled Jobs,as of now everything is working fine, i just wanted to know if there is any option to monitor the Jobs, for eg, if a Job hangs for more than 5hrs, can we set an alert email to notify that the Job has Hung ?
So that we can troble shoot whats wrong with the pacakge or the Job..
-Thank you
March 22, 2010 at 11:14 am
Yes you could do that. One method is to create another job that fires off every so often. The job will check the status of each of the "monitored jobs" and, based on criteria, fire off an alert or do nothing.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 22, 2010 at 11:20 am
Could you please elloborate it?
There are options only when Job suceeds,fails and completes, and i have about 15Jobs schedules for my Database, how can i schedule the Job for all those 15 Jobs..?
I am new to SSIS ..Please Help...
March 22, 2010 at 11:28 am
Your monitoring job would run a script to check the job tables in the msdb database.
(sysjobhistory check the run_status column)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 23, 2010 at 12:15 pm
How do i create a package for the systemtable in MSDB, because i cannot see the system tables, when i select from ole db source connection...
I need to create Job which notifies me that the Job has run for more than 18000 seconds(5hrs)
Please Help...
March 23, 2010 at 12:51 pm
rds207 (3/23/2010)
How do i create a package for the systemtable in MSDB, because i cannot see the system tables, when i select from ole db source connection...I need to create Job which notifies me that the Job has run for more than 18000 seconds(5hrs)
Please Help...
I wouldn't do this from another SSIS package. A simple tsql script to be executed by an account with adequate permissions in msdb.
If you don't have those permissions, you should speak with your DBA.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply