Read Robot schedule information

Padmanabhan, Venkatesh 241 Reputation points
2021-08-19T05:22:09.413+00:00

Hi.

How to retrieve job information from Robot schedule (https://www.helpsystems.com/products/job-scheduling-software-ibm-i ) and utilize that as a web page in ASP.NET for end users ?

I have tried the below code, but getting error:

private void IseriesConnect()
        {
                           int count = 0;
                using (iDB2Connection conn = new iDB2Connection(ConfigurationManager.ConnectionStrings["IbmIConnectionString"].ConnectionString))
                {
                    string sqlStatement = "SQL statement" ;

                    iDB2Command cmd = new iDB2Command(sqlStatement, conn);
                    cmd.CommandType = CommandType.Text;

                    conn.Open();
                    count = (Int32)cmd.ExecuteScalar();
                    conn.Close();
                }
     }

In the web.config

<add name="IbmIConnectionString" connectionString="DataSource=servername;DefaultCollection=ROBO;User Id=username;Password=pwd;"/>

Error:
Message : The ConnectionString property is invalid.

MessageDetails : UserID

I have tried : UID, User Name, UserName, UserID, User ID - but same error

Is there a way to read this data ?

Thanks

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,403 questions
{count} votes